I posted a question yesterday (copied below) about saving a workbook that
was created in 2003 but will be used in Excel 97. Every time the file is
saved I get the "This file was created using a later version..." dialog box.
I know that the dialog box says to fix that by saving the file using "Save
As.." but that doesn't work.

I save the file in Excel 2003 as a "Microsoft Office Excel Workbook"

Then I open it in Excel '97

When I try a save, I get that warning.

If I save it by clicking "Yes" I lose no functionality.

If I don't save it by clicking "No", and then do a File-Save As in Excel 97
with a new name and file type of "Microsoft Excel Workbook" it changes
nothing.

No matter what I try, all the workbooks I created with Excel 2003 have this
prpoblem when they are used with Excel 97.

The only solution was to Export all my macros. Create a new workbook in
Excel 97. Copy all the worksheets to the new workbook And then Import all my
macros. Not all that big of a deal except that some of the range names do
not copy over for some reason and I have to manually rename those that are
mnissing. I also have to change the color on any shaded cells since the
colors do not match after I copy the worksheets to the new workbook.

What am I missing here?

Any suggestions would be much appreciated.

Ken Loomis


I developed a workbook with a set of macros using Excel 2003. But this will
be used on a system with Excel 97.

I have tested it on Excel 97 and everything works fine, but now every time
the file gets saved from Excel 97, it gives the warning dialog box that
starts out "This file was created using a later version..." and I have to
click "Yes" to continue.

Is there some way to change something so I do not have to always click "Yes"
every time I save the worksheet?

If so, what and how?
====================

I