Home |
Search |
Today's Posts |
#1
|
|||
|
|||
function values do not refresh
When i first created a spread sheet to make calculations. It would
automatically update as i added or deleted values. However, the document has been saved and has not been used in a while. I have to go to each of the cells, go to the formula bar, move the cursor after the formula and press enter just to get the cell to update. I don't know what the problem is. It is too time consuming to go to each cell just to have it recognize the new values. Any suggestions? Thanks! |
#2
|
|||
|
|||
Does the word 'Calculate' appear in the status bar at the bottom of the
screen? If so, then use the menu to choose Tools | Options, navigate to the Calculation tab and check Automatic "Jacob" wrote: When i first created a spread sheet to make calculations. It would automatically update as i added or deleted values. However, the document has been saved and has not been used in a while. I have to go to each of the cells, go to the formula bar, move the cursor after the formula and press enter just to get the cell to update. I don't know what the problem is. It is too time consuming to go to each cell just to have it recognize the new values. Any suggestions? Thanks! |
#3
|
|||
|
|||
Thanks so very much because that was getting on my last nerves! :-)
"Duke Carey" wrote: Does the word 'Calculate' appear in the status bar at the bottom of the screen? If so, then use the menu to choose Tools | Options, navigate to the Calculation tab and check Automatic "Jacob" wrote: When i first created a spread sheet to make calculations. It would automatically update as i added or deleted values. However, the document has been saved and has not been used in a while. I have to go to each of the cells, go to the formula bar, move the cursor after the formula and press enter just to get the cell to update. I don't know what the problem is. It is too time consuming to go to each cell just to have it recognize the new values. Any suggestions? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Indirect( ) function loosing values when spreadsheets are closed | Excel Worksheet Functions | |||
LOOKUP FUNCTION WITH SUMS VALUES | Excel Discussion (Misc queries) | |||
Variable values in Index function | Excel Worksheet Functions | |||
Finding real values of a function | Excel Worksheet Functions | |||
need to save values from a function before it changes | Excel Worksheet Functions |