WB Not Calculating Automatically

J

Jon Martin

Hi,
We are using Office 2003, and use many WB's, last night one particular WB
when cells were changed would not update simple formulas. I have checked that
the calculation tab is set to automatic as I know this can cause this. Even
in the WB pressing F9 at the time would also not work.
Don't know if it's any coincidence but we have just upgrade to Windows XP
operating system.
Any suggestions out there.
Many thanks.
 
C

CLR

Does this file act the same on different computers?
If not, then the problem is probably with the computer where it acts up.
If so, then one possibility might be that a macro is turning off
calculations as the workbook is opened......try starting the file with macros
disabled to see if this might be the cause.......

hth
Vaya con Dios,
Chuck, CABGx3
 

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

Top