Hate having to press save just to update cells

  • Thread starter Thread starter Julie
  • Start date Start date
Check if your calculation is still set to auto.

<Tools> <Options> <Calculation> tab,
Make sure "Automatic" is checked under "Calculation".
 
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.
 
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
 
Back
Top