Hate having to press save just to update cells

[Julie]

I am not sure how this happened. I have been working in the same file
for a long time but now all of the sudden, cells won't update until I
hit save. Is there a way to fix this. I have a huge file and it is
such a pain to wait 10 seconds every time I want to see the calculation
appear.

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Software!
http://www.ozgrid.com/Services/excel-software-categories.htm **

 

[Ragdyer]

Check if your calculation is still set to auto.

<Tools> <Options> <Calculation> tab,
Make sure "Automatic" is checked under "Calculation".

 

[Julie]

It was selected but I unselected it and selected it again and it works.
Thanks so much!
Julie

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Software!
http://www.ozgrid.com/Services/excel-software-categories.htm **

 

[David McRitchie]

Hi Juli,
Try getting rid of your temporary internet files.
From IE : Tools, Internet Options, General (tab), Delete Files

Delete temporary files from your Command (DOS)
del *.tmp /s

Within Excel try File, properties, General (tab), write down the size

Fix your last cells -- This will usually fix the workbook
Lastcell, Reset Last Used Cell
Reset All Lastcells in the Active Workbook (#resetall)
http://www.mvps.org/dmcritchie/excel/lastcell.htm#resetall
install and run the Reset_all_lastcells macro.

On a worksheet use Ctrl+End to check the last cell
it should be the intersection of your last used row and last used column.

Receck properties for size. Of course any change would
only be effective if you save the file.

Do you have a lot of formats assigned individually as opposed
to formatted by columns at time. Do you have a lot of dependent
formulas. I hope you are not trying to use SUM to get running
balances.

Ten seconds may not be such a long time, but since you note
that it is higher than what you had before will accept that at
face value.

 

[David McRitchie]

Sorry I misread your posting, saw 10 seconds for calculation
and read that as the problem.

Having something turn off calculation and not knowing it can
be very disconcerting. I sometimes place a macro in my
workbook to check to see if calculation was turned off, and
then turn it on. Trying to get closer to when it happened make
it more likely to find the cause of the problem, such as a bad
macro or even a bad add-in.
http://www.mvps.org/dmcritchie/excel/slowresp.htm#addins