"Gord Dibben" wrote:

You negelected to state ehich version of Excel you are running?

I'm using 2007


2003 will save as 95/5.0 format.

Yes, however, the third or forth time I save the spreadsheet, it is
converted to the 2003-2007 format without prompting me to do so. So, I'm
constantly "Save AS" the file. I need to keep this file as a 95 spreadsheet
in order to work with our payroll department, which the manager thereof
hasn't yet decided to upgrade.


Gord Dibben MS Excel MVP

Spiky,

Regarding your question, the spreadsheet I have is in 95 format--.xls. I am
trying to convert it to a 2003 - 2007 format. I save the spreadsheet as a
2003-07 file, and when I open it, Excel still shows it in [Compatibility Mode]

Thanks for the input.

Tim