Excel recalculates formulas

  • Thread starter Thread starter GMW
  • Start date Start date
G

GMW

I have a quick question.



I upgraded to Office 2000. Now whenever I open an excel file from someone,
it says "Microsoft Excel recalculates formulas when opening files last saved
by an earlier version of Excel". Can I make this automatically save so I do
not have to click yes or no each time? I have clicked around but have not
found anything. Can you tell me how to change this?



Thanks, Tanya
 
I'm not sure if you can.

But you can hit almost any key to dismiss that dialog (if I recall correctly).

Enter/spacebar/escape key

And if you save that workbook, then it should appear next time you open that
workbook.
 
I am not seeing my posting in the other group, which is why I came to this
one. Any chance someone can repost the registry tweak?
 
I agree with what JE wrote. So I tried it and google didn't have (yet???).

Here's a copy:

From - Wed Apr 07 20:23:50 2004
From: "Jim Rech" <[email protected]>
Subject: Re: Excel recalculates formulas when opening files last saved by an
earlier version of Excel
Date: Wed, 7 Apr 2004 13:47:26 -0400
Newsgroups: microsoft.public.excel.programming

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.

--
Jim Rech
Excel MVP
|I upgraded to Office 2000. Now whenever I open an excel file from someone,
it says "Microsoft Excel recalculates formulas when opening files last saved
by an earlier version of Excel". Can I make this automatically save so I do
not have to click yes or no each time? I have clicked around but have not
found anything. Can you tell me how to change this?
I am not seeing my posting in the other group, which is why I came to this
one. Any chance someone can repost the registry tweak?
Click to expand...
 
That !#%!@ing thing wasn't there minutes ago. (or maybe I just missed it!)

Dave "Magoo" Peterson
 
But it happens soooo often.

I meant by my mcgoo post that I found it the second time I looked.

Hmmm. There should be a www.mcgoogle.com

A cross between McDonald's and Google. Over a billion served would really hit
home.

And there is a mcgoogle.com site! (just back from Google. Not as exciting as
actually leaving the house, but...)
 
Back
Top