microsoft office excel - compatibility checker - popup window whensaving an XLSM file.

[Excel]

When I try to close one of my spreadsheets of type .xlsm, I get a pop-
up window entitled, "microsoft Office Excel - Compatibility Checker".
This window further explains "the following features in theis workook
are not supported by eaelier versions of Excel. These features may be
lost or degraded when you sve this workbook in an earlier file
format. Click Continue to save teh workbook anyway. To keep all of
your featuress, clieck Cancale, and then save teh file in one of the
new file formats". However, I'm trying to save it as a new file
format: .xlsm.

The window further explains the "following features" : three
occurrences of "minor loss of fideility: Some cells or styles in this
workbook contain formatting that is not supported by the selected file
format. These fomats will be converted to the closest format
available".

I am able to save other spreadsheets of file type .xlsm without
encountering this problem.

Why this window is popping up... and what may be done to correct it?

I'm using Excel 2007, windows 7.

 

[Dave Peterson]

This is a guess.

Maybe the file/workbook was saved with a .xlsm extension, but in the old
xl97-xl2003 file format.

I'd try doing a SaveAs and making sure that the "file of type" is set for xl2007
(.xlsm).

 

[Excel]

This is a guess.

Maybe the file/workbook was saved with a .xlsm extension, but in the old
xl97-xl2003 file format.

I'd try doing a SaveAs and making sure that the "file of type" is set forxl2007
(.xlsm).

Dave,
when I select the drop down arrow after "save as", I choose "Excel
macro-enabled workbook (*.xlsm) as "save as type:". I only have one
type of .xlsm file in the list to pick from -- it doesn't specifiy
whether or not it is 2007 or earlier. when i do so, i still get the
message. When i do so, I still get the "compatibility checker" pop-up
window.

when I just select the 'excel macro-enabled workbook save teh workook
in the xml-based and macro-enabled file format" (without picking the
drop down after "save as"... the "compatibility checker' pop-up window
still pops up.

I've removed the checkbox from the "check compatibility when saving
this workbook", and the "compatibility checker" pop-up window is
gone. Still, it's curious why this happens.

Plus, the "compatibility checker' window shows there are 3 such
compatibility errors in this workbook, and the number "3" includes a
hyperlink. Unfortunately, the hyperlink only goes to generic Excel
help rather than the cells causing the problem.

 

[Dave Peterson]

I don't have a guess.

Ron de Bruin has a page for compatibility problems, but I'm not sure if it will
help you (but it can't hurt to read it):

http://msdn.microsoft.com/en-us/library/gg132972.aspx