Why does saving as XLSM trigger Compatibility Checker?

[Colin]

If I save as XLSX, Excel 2007 knows not to bother with the compatibility
checker, because I'm not saving in an old format. But when I try to save my
files with macros in the new formats that support macros, like XLSM or XLTM,
it yaps to me about compatibility errors (just minor formatting referring to
the cells that use the new pallette).

I don't care about backward compatibility for this particular file as I'm
the only one who will use it. Since I'm not saving in an older format, why
does it pester me with this every time I try to save?

Is there any way to stop this just for saving in the new formats? I still
want it to alert me about compatibility problems if I actually try to save
in an older format. This seems like common sense - check for compatibility
with older formats when saving in older formats and not when saving in the
new format.

Thanks for any insight or help,
Colin

 

[GMorris]

That's strange, and it's never happened to me before.
I have seen the messages when saving in an older format,
but not just saving as an XLSM or anything like that.
What are you referring to when you say "cells that use the
new pallette"?

As for a way to make it stop, I couldn't even fathom a
guess unless I could re-create the scenario myself. I'm
sure there is a way to get around it with a VBA routine
or something, I just have no way to re-create it here.

 

[Jim]

Hi Colin

I have had the same problem. The only thing I could see that could be
causing it was the fact the the spreadsheet started out as an XLS. I opened a
new sheet saved it as an XLSM. I then dragged the sheets on to the new xlsm
and copied my macros and userforms.

When I tried to save the new xlsm i no longer got any Compatibility Checker
showing up on save.

It seems like Excel still sees the old file version when saved as an xlsm.

Hope this is of some use to you.

Cheers

Jim