Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have an Excel spreadsheet that was initially created with Excel 2007. However, Excel 97 is used regularly to edit this document and the annoyance is that Excel always prompts before saving:

The file was created using a later version of Microsoft Excel. If you save this file using Microsoft Excel 97, information created with features in the later version may be lost.

OK... I continue with the save. But it prompts again the next time I save. I would have hoped that this information would have been overwritten when I save the document, but it is not.

How can I prevent this dialog popping up every time I save this document, without recreating the document in the old version of Excel?

share|improve this question
Is this any help (ie can you get at the 8 to change it to 0 - not that I know any consequences nor whether that would work anyway!)? – pnuts Oct 5 '12 at 9:47
@pnuts: Are you referring to the file format... BIFF8 for Excel 97 - is that what that code outputs? Although if I have already saved it from Excel 97 then the file format has presumably been overwritten although there is still a flag in the file that indicates that a later version created it. I have had a quick look at the file using a hex editor, but I don't currently know enough about the file format to make any changes! – w3dk Oct 5 '12 at 12:02
Sorry, I’m way out of my depth. 8/BIFF8 are clearly not coincidence but this does not help you since BIFF8 is also the format for versions after Excel 97 and, based on the other question, it seems only Excel 97 preserves evidence that it created the file even if CalculationVersion is set/rest after creation (maybe??). do provide details of the Excel 97 file format, if you must, but definitely not something I would tamper with! – pnuts Oct 5 '12 at 14:00

Can you try setting a before save macro that would disable that warning? something like

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
End Sub
share|improve this answer
Thanks for the suggestion, although this doesn't work unfortunately. The warning prompt appears before the BeforeSave event fires. – w3dk Oct 5 '12 at 8:44

The only way I can think to solve this is to open the file in Excel 2007 and do a Save as, choosing the Excel 97-2003 Workbook format. Then you should be able to use it with Excel 97 without the warning.

enter image description here

share|improve this answer
No, it is not recreating, it is simply saving it in an older version Excel. – CharlieRB Oct 5 '12 at 14:19

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .