Excel 2003 no longer automatically updates equations & charts

B

bnault2006

My copy of Excel 2003 has recently stopped automatically updating formulas
and charts in my worksheets, i.e. when I change values I have to basically
reset the equation or my source data to see the changes. I noticed this
after installing Office SP2, and opening old Lotus 1-2-3 files, although all
my Excel files are affected, not just the ones converted from Lotus. Any
thoughts?
 
B

bnault2006

Gary''s Student said:
Tools > Options > Calculate > Automatic
Click to expand...

awesome...thanks. I have no idea how that option got changed, but it seems
to be working now.
 
D

Don Guillett

Excel takes calculation mode from the 1st workbook opened, unless changed.
 

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

Similar Threads

Embed the same Excel multiple times 0
Excel 2007: continuously update scatter chart from scroll bars 1
Drop down in Graph (excel 2003) 2
Can't drag new data to chart in 2007. 1
Store Excel value 0
pie chart data labels auto update ? 0
Linked excel charts to Word doc 0
My Excel Chart No Longer Auto Updates 1

Top