LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
FISH
 
Posts: n/a
Default Functions not "recalculating" when input changes ???

I'm using Excel 2002 (on my PC running XP Home)

I'm basically a novice to excel, but can create simple templates for simple
needs. I'm currently creating a template that will simply add the sum of a
certain
number of cells. The problem is, the results don't automatically
"re-calculate".

For example:
In cell E107 I've added the function: =SUM(E6:E104)
The result that came up after I added this function is the correct amount.
The problem is, when I change the amount entered into one of the cells
within the E6-E104 range, the result in E107 remains the same as it was
prior to the change (and therefore no longer correct).
It does not recalculate the sum automatically.

What can I do to have this function recalculate automatically as soon as a
cell within the range changes (as it always has in the past)?

Thanks in advance...




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Functions not "recalculating" when input changes ??? FISH Excel Worksheet Functions 1 September 7th 05 07:56 PM
Visible rows and functions that work tracy Excel Worksheet Functions 2 August 19th 05 05:25 AM
Input Form vba help mdalzell Excel Discussion (Misc queries) 0 April 8th 05 03:57 PM
function IF / how to input pictures into this functions / merlin68 Excel Worksheet Functions 8 April 5th 05 04:19 PM
Functions ALex Excel Worksheet Functions 1 March 16th 05 06:25 PM


All times are GMT +1. The time now is 11:39 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"