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

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

Make sure calculation is set to automatic.

ToolsOptionsCalculation tabAutomaticOK

--
Biff
Microsoft Excel MVP


"jimmy" wrote in message
...

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

T. Valko wrote:
Make sure calculation is set to automatic.

ToolsOptionsCalculation tabAutomaticOK

F9 do it too. Right ?

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

Make sure calculation is set to automatic.

ToolsOptionsCalculation tabAutomaticOK

F9 do it too. Right ?

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

auto update formula data in linked workbook ?
 

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.