Excel

[thewayner]

Is there a way to turn off pop up window that asks to recalculate formulas
when opening files saved by an earlier version of Excel?

[Gord Dibben]

Quote from a post by Jim Rech............

Jim Rech Apr 7 2004, 10:48 am

You get this particular message only when you open a workbook that was
already fully calced (as far as the earlier version of Excel was concerned)
but Excel 2000 calced it anyway just because it was from an earlier version.

To stop this you need to make a registry entry (Start->Run "Regedit" (no
quotes)).

Under:


HKEY_CURRENT_USER\Software\Microsoft\Office\9.0\Excel\Options
create a new DWORD item named: FullCalcOnLoadOldFile

Leave its value at the default of 0.

Note that even after this change if the workbook was not fully calced, and
you calc it, you'll get the usual "save changes" prompt.

......................................

Note: In Jim's instruction, he refers to Excel 9.0 which is 2000.

Excel 2002 is 10.0........Excel 2003 is 11.0.

Same fix applies.

Gord Dibben Excel MVP

On Fri, 28 Jan 2005 06:21:02 -0800, thewayner
<thewayner@discussions.microsoft.com> wrote:

>Is there a way to turn off pop up window that asks to recalculate formulas
>when opening files saved by an earlier version of Excel?

[Nuno Ramalho]

hello.

I do your sugested action but don't work with me, i'm continue have #value
in all cells.
Maybe you now what i'm doing wrong, i have a 2000 excel file and try to open
it in 2003 excel version.

Thanks
Nuno Ramalho

"Gord Dibben" wrote:

> Quote from a post by Jim Rech............
>
> Jim Rech Apr 7 2004, 10:48 am
>
> You get this particular message only when you open a workbook that was
> already fully calced (as far as the earlier version of Excel was concerned)
> but Excel 2000 calced it anyway just because it was from an earlier version.
>
> To stop this you need to make a registry entry (Start->Run "Regedit" (no
> quotes)).
>
> Under:
>
>
> HKEY_CURRENT_USER\Software\Microsoft\Office\9.0\Excel\Options
> create a new DWORD item named: FullCalcOnLoadOldFile
>
> Leave its value at the default of 0.
>
> Note that even after this change if the workbook was not fully calced, and
> you calc it, you'll get the usual "save changes" prompt.
>
> ......................................
>
> Note: In Jim's instruction, he refers to Excel 9.0 which is 2000.
>
> Excel 2002 is 10.0........Excel 2003 is 11.0.
>
> Same fix applies.
>
> Gord Dibben Excel MVP
>
> On Fri, 28 Jan 2005 06:21:02 -0800, thewayner
> <thewayner@discussions.microsoft.com> wrote:
>
> >Is there a way to turn off pop up window that asks to recalculate formulas
> >when opening files saved by an earlier version of Excel?
>
>

[Gord Dibben]

But, do you still get the popup window asking to recalculate formulas?

The #VALUE! error could be the result of a different problem.

Broken links?

Improperly entered Array formulas?


Gord

On Thu, 10 Feb 2005 18:09:07 -0800, Nuno Ramalho <Nuno
Ramalho@discussions.microsoft.com> wrote:

>hello.
>
>I do your sugested action but don't work with me, i'm continue have #value
>in all cells.
>Maybe you now what i'm doing wrong, i have a 2000 excel file and try to open
>it in 2003 excel version.
>
>Thanks
>Nuno Ramalho
>
>"Gord Dibben" wrote:
>
>> Quote from a post by Jim Rech............
>>
>> Jim Rech Apr 7 2004, 10:48 am
>>
>> You get this particular message only when you open a workbook that was
>> already fully calced (as far as the earlier version of Excel was concerned)
>> but Excel 2000 calced it anyway just because it was from an earlier version.
>>
>> To stop this you need to make a registry entry (Start->Run "Regedit" (no
>> quotes)).
>>
>> Under:
>>
>>
>> HKEY_CURRENT_USER\Software\Microsoft\Office\9.0\Excel\Options
>> create a new DWORD item named: FullCalcOnLoadOldFile
>>
>> Leave its value at the default of 0.
>>
>> Note that even after this change if the workbook was not fully calced, and
>> you calc it, you'll get the usual "save changes" prompt.
>>
>> ......................................
>>
>> Note: In Jim's instruction, he refers to Excel 9.0 which is 2000.
>>
>> Excel 2002 is 10.0........Excel 2003 is 11.0.
>>
>> Same fix applies.
>>
>> Gord Dibben Excel MVP
>>
>> On Fri, 28 Jan 2005 06:21:02 -0800, thewayner
>> <thewayner@discussions.microsoft.com> wrote:
>>
>> >Is there a way to turn off pop up window that asks to recalculate formulas
>> >when opening files saved by an earlier version of Excel?
>>
>>