CDROM-Guide forums

Go Back   CDROM-Guide forums > Operating System Forums > Windows 2000
FAQ Calendar Mark Forums Read
Open   CSec   Data   DevDrv   CoOp   Audio   CDRW   CDG   VCD   DVD   HD DVD   Mac   VGB   PS2   DC   Xbox  


 
 
Thread Tools Display Modes
  #1  
Old May 16, 2003, 08:47 AM
shicks1014 shicks1014 is offline
Junior Member
 
Join Date: Apr 2003
Posts: 36
Exclamation Microsoft Excel 2000 --formula problem [; ; win2K]

sponsored links

 
When copy and pasting a formula down a group of cells, the actual formulas are reading correctly but the sum is the number from the first copied formula.

What is causing this? Should I reinstall the software?

We are on a network, and it seems to be happening to a few workstations. Do we maybe have a virus that Norton did not detect?

PLease advise if you have any tips. Thanks!
  #2  
Old May 16, 2003, 11:48 AM
Captain Captain is offline
Veteran
 
Join Date: Jun 2001
Location: UK
Posts: 1,661
Default

Can you paste the formula here? It's probably because formulas can contain absolute and relative references to other cells and you'll want the oposite to what its doing. Or mail me the spreadsheet and i'll take a look for you.

I'd guess the formula has $ signs next to the cell references like $A$5 instead of A5.
  #3  
Old May 16, 2003, 03:55 PM
joer4 joer4 is offline
Member
 
Join Date: Feb 2003
Posts: 67
Default

try copying the cells, and chose paste special from the toolbar, that may have the option you need (such as paste formula or something).
 

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
cable modem install problem on windows 2000 ThE SnAkE Device Driver Questions 1 Sep 18, 2002 06:56 AM
strange outlook 2000 problem.. ellal Open to All Computer Related Topics 8 Jun 03, 2002 11:34 AM
problem with microsoft frontpage 2000 Mores Open to All Computer Related Topics 3 May 27, 2002 10:35 PM
Plextor Manager 2000 problem [Dell ; XPS233; win98SE] FredE CD-R & CD-RW 1 Mar 23, 2002 04:35 PM
Yamaha 2100E and Windows 2000 = Problem [; ; win2KPro] casper2000 CD-R & CD-RW 3 Jan 17, 2002 08:23 PM


All times are GMT -5. The time now is 05:38 PM.



Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 1996-2009 CDROM-Guide.com. All rights reserved