False last saved by an earlier version prompt

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

On a new laptop with a new install of Excel 2002 SP3, I create a spreadsheet by
going to a folder, right-clicking and choosing new Excel Worksheet. I then
open
the sheet, enter values in two cells, create a formula in a third cell, exit
Excel saving
the sheet as I exit. If I reopen that same worksheet and make no changes, I
get a
message upon closing "Microsoft Excel recalculates formulas when opening files
last saved by an earlier version of Excel." I found an article in
Microsoft's Knowledge
base that gives directions on how to turn off the recalc of formulas
(Tools...Options...Calculation - change to manual and clear "Recalc before
save"
option), but I would like to know why and find a resolution to my problem
because
it is not caused by the same thing identified by the KB article I found.
 
Hi Kevin,
If I reopen that same worksheet and make no changes, I
get a
message upon closing "Microsoft Excel recalculates formulas when opening files
last saved by an earlier version of Excel."
Click to expand...

Open the file, choose file, save as and check at the bottom of the screen. Make
sure you save as "Microsoft Excel workbook", not as an older version.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com
 
The "Save As" operation has the correct file type as the default "Microsoft
Excel
Workbook." If I click on "Yes" to the prompt that mentions an earlier
version, or
I simply save the worksheet (after opening it a second time), then the
prompt never reappears.
 
Hi Kevin,
The "Save As" operation has the correct file type as the default "Microsoft
Excel
Workbook." If I click on "Yes" to the prompt that mentions an earlier
version, or
I simply save the worksheet (after opening it a second time), then the
prompt never reappears.
Click to expand...

Check your HD to see if there is a file called Book.xlt in there somewhere
(presumably in the XLSTART folder). Maybe this one is in an older format, it
is used as the basis of any new workbook you start.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com
 
I checked my entire HD, and no sign of this file.
Any other suggestions?

(Jan, thanks for your help thus far).
 
Back
Top