Open the destination wb first or put a change to automatic calculation in
the workbook_open and/or auto_open

--
Don Guillett
SalesAid Software

"Chris" wrote in message
...
I spoke with the user and he told me that he knew that because "calculate"
would appear on wb at the bottom left. He also said that F9 should
calculate
the wb when set to manual, but he had to do a Crtl+F9. Is there any other
possible cause and solution? Thanks

"Don Guillett" wrote:

The first wb to open sets the calculation.

--
Don Guillett
SalesAid Software

"Chris" wrote in message
...
How is that possible if the spreadsheets aren't linked?

"Don Guillett" wrote:

The other sheet was probably opened first and reset calculation to
manual..
Check it's options.

--
Don Guillett
SalesAid Software

"Chris" wrote in message
...
Today a user experienced a situation where a spreadsheet that he
had
open
did
not calculate properly. The auto-calculate function was turned
on,
but
when inputs were changed, the final results would remain unchanged
until
he hit the "super-calculate" function (control-alt-f9). He would
then
watch the final results change.

He had another excel file open at the time (Note: these files were
not
linked). When he closed this file, the problem corrected
itself.