why is excell not updating my formula data within a workbook?

  • Thread starter Thread starter jimmy
  • Start date Start date
Make sure calculation is set to automatic.
F9 do it too. Right ?
Click to expand...

Well, yes, sort of; F9 will recalculate the sheet... once. What Biff posted
is a permanent re-setting of the option (well, permanent until changed again
at least<g>).

Rick
 
And me also get a message
'Unable to read file'
after I click OK when Excel give the options to update the links or not.
How to solve this?
I want the automatic update everytime I open my workbook.
Please help.
 
Back
Top