Autocalculate
 

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.

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.

How large was the file that acted up? I have seen this problem surface with
large spreadsheets that have many calculations


"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.

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.

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.

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.

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.