updating linked cells

  • Thread starter Thread starter pnc1221
  • Start date Start date
P

pnc1221

I've recently updated to office 2003, and I'm having trouble with
Excel. the problem is with worksheets that do not automatically
update the results of new cell entries. For example, If I add a new
value in a cell that is in a range that calculates the average of that
range, the new value is not automatically included in the calculation,
although the formula indicates that it should be. the only fix that
I've been able to come up with is to go to every cell and update it
manually by double-clicking it. This is extremely irritating! Any
suggestions? This was not a problem in Office 97 (?) which the
spreadsheet was created. Thanks.
 
Do you have auto calculation enabled? Tools/Options/Calculation?Automatic

--
Ken Russell

(e-mail address removed)
Remove yourhat to reply by e-mail
..
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
Configuration of WordPress for enabling updates eg plugins and WordPress itself.. 1
Excel 2007 extremely slow to delete cells 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Cell not calculating after importing data 2
excel cells changing to "#VALUE!" whenever another file is opened 8
Turn off "CALCULATE" on bottom of Excel worksheet. near "Ready" 2
Conditional formatting in Excel 2010 2

Back
Top