Email:      Pass:    Pass?
Close Window   
TE
Subscribe for Email Updates!
Excel tips, help, and more!
E-mail:


Advertisements


Free Excel Forum

Compatibility Mode Issue

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More

Something bizarre is happening and I haven't been able to track down a concrete answer as to why...

Our company upgraded some of our Excel versions to 2007 last year. But because some of our employees still have 2003, we have to still save in .xls for those documents they are viewing (for some reason we haven't been able to get people Excel Viewer 2003). Thus we're always having to save in compatibility mode...

Over the last six months or so after I save a spreadsheet in .xls and re-open it, all formatting is lost. This doesn't happen all of the time, but slowly all of our continually updated spreadsheets are biting the dust.

When a spreadsheet gets reformatted, it seems the only fix is to create an entirely new spreadsheet and save it in .xlsx. It will allow you to reformat the same spreadsheet again, but as soon as you save it, it reverts back to the unformatted version.

I have a feeling this is due to these spreadsheets being originally created in .xls, then continually updated in 2007, but I'm really not sure. Has anyone else encountered this or know of a solution?

Thanks so much!

William


Similar Excel Video Tutorials

Helpful Excel Macros

Disables the "Save As" Feature in Excel
- This macro will disable the Save As feature in excel. This means that a user will not be able to resave the workbook un
Automatically Run a Macro at a Certain Time - i.e. Run a Macro at 4:30PM every day
- Automatically run an Excel macro at a certain time. This allows you to not have to worry about running a macro every da
Delete Empty Columns
- This macro will delete columns which are completely empty. This means that if there is no data within the entire column
Close a Workbook after a Time Limit is Reached
- This macro will automatically close the workbook in which it is located after that workbook has been opened for a certai
Output the Name of the Current Excel Workbook Including Extension - UDF
- Free Excel UDF to display the name of the current Excel workbook, including the workbook extension. This function has n

Similar Topics







My company mostly uses Excel 2003. As people have their computers upgrades the new ones have Excel 2010.

We have a shared network drive where we save spreadsheets. Many different people open and update in them. Also these spreadsheets have Macros in them.

If someone with 2010 opens the file, it updates to their version. If they save it, of course, the 2003 people can't use it anymore. If they do a Save As and under "Save as Type" they select 2003.xls, then the 2003 people can open it, but it is "read only", and the macros don't work.

Does Microsoft have some kind of work around for multiple users with different versions?


I have been using Excel 2007 for over a year, but many of the files I access are still in Excel 2003 format. I do not want new files to open in compatibility mode, but they usually do. I have gone to Excel Options and changed the setting for "Save Files In This Format" to Excel Workbook instead of Excel 97-2003 Workbook, but then it will switch back (really often) to Excel 97-2003 Workbook as the setting. I assume that this may be happening because I continue to have to open files created in earlier versions. Does it periodically save the current settings as normal settings? Can I turn that off somehow? I'm really tired of having to go change it all the time.

Thanks for your help!


I know it isn't popular to continue looking backward however company policy requires us to keep our 2007 installations saving in Excel 97-2003 workbook (.xls) format. This is mostly a requirement with our offsite document management system.

Problem is, if you choose "Save As" it reverts back to the 2007 (.xlsx) XML format. Excel is set up by default to save in .XLS format in Options --> Save.

When one of our users chooses "Save," the Office integration kicks in and the file is saved to offsite. In the 2007 XML format (.xlsx).

How can this be? Do you know? How do I stop it?

Thanks for your help in advance,

David G.


Hi to you all,

Its been a long time! I have a Excel 2003 workbook running just fine in compatibility mode in Excel 2007 but, as soon as I save that same project as a 2007 workbook, vba goes crazy! Everytime I open the Workbook it pops me 3 messages that "This action will reset your Project" Continue Anyway. Why does this happen in 2007 and not with 2003. Why cant VBA stop on the "error" or whatever or wherever it encounters the problem?

I find it funny that 2007 handles it flawlessly in compatibility mode, just as 2003 would, but oh boy!, don't you dare and save it as a 2007.

Would any of you experts have an answer fro me, Please?

Thank you!


I have encountered an issue that completely stumps me.

Some background-
First off, I understand that Excel 2003 only allows 4000 unique cell formats. Now, most people in my company are using excel 2007, but some are still using 2003. For this reason, we still try and save our files in .xls format.

I have a specific file which I know contains more than 4000 unique formats and when I try to save it as a .xls file (using excel 2007), the compatibility checker gives me an error, as I would expect, that says "Significant loss of functionalty". I expect this error because of my comment above.

Next, the Problem that completely stumps me-
When another user tries and saves this SAME file as a .xls (using excel 2007), the compatibility checker DOES NOT say any Significant loss of functionaly is possible. They only get a minor loss of fidelity error, which shows no indication that their spreadsheet is about to lose all of the formatting if they continue to save.

Is there some sort of excel setting that is preventing this user from seeing these critical errors? ANY ideas will be greatly appreciated! Thanks!


I just put 2007 on my computer to test it out, but my entire office( and almost all of our customers) are using 2003 or less.

I thought there was a way to create a document AS a 2003 document. I know how to save-as a 2003 document, but my issue is that when I open a document that I created before my upgrade in 2003- it opens in 2007, then I try to save it as 2003 and then there is a conversion problem and will only keep 255 characters per cell.

I know I can create documents in 07 and people that have 2003 can install the viewer, but some of our customers don't even know how to use e-mail. Therefore, I was thinking there is a way to create something AS a 2003 document, or open in 2003 mode....???


I have someone in the company that I work for that is using Excel 2007 in compatibility mode, that is trying to make changes to an Excel 2003 file.

The file in question is a large one. She can type in the rows and columns and anything that she types will save. However if she trys to make any changes to the file in terms on calculations or highlighting specific columns, then these changes are not saved.

I have found out though that if she saves this 2003 file in the 2007 format, then all over her changes will save. She can't save it in the 2007 format due to some people still on 2003 that edit this file as well.

Any clues as to why this might happen?


I'm getting a warning message when I try to save a particular .xls file in Excel 2007. It's clear to me that the message is erroneous, but our customers will find it very confusing. If anyone can shed light on what causes the message or how to work around it, I'd be very grateful.

I open this particular Excel 97-2003 workbook in Excel 2007, and it shows that it's running in compatibility mode. So far so good. But then when I try to save it with another name but still file type Excel 97-2003 workbook (*.xls), the compatibility checker comes up and complains as follows:

--- start of compatibility checker message ---

The following features in this workbook are not supported by earlier versions of Excel. These features may be lost or degraded when you save this workbook in an earlier file format.

Significant loss of functionality

This workbook contains data in cells outside of the row and column limit of the selected file format. Data beyond 256 (IV) columns by 65,536 rows will not be saved. Formula references to data in this region will return a #REF! error.

--- end of compatiblity checker message ---

Just after the message are hyperlinks for "Find" and "Help". If I click "Find", it goes to cell F42, which is well within the limit of 256 columns and 65,536 rows. If I click "Help", it goes to some generic help which is not useful.

The error message doesn't make sense anyway, because I'm in compatibility mode, having loaded an Excel 97-2003 workbook, so the original file couldn't possibly have any data outside the limits, and I haven't changed anything. Even if I did, compatibility mode shouldn't let me go outside the limits.

I get the same message if I just do Prepare->Run Compatibility Checker. The problem happens quite consistently with this workbook.

I've opened a support request with Microsoft about this, but if anyone has seen this before and has a suggestion, I'd love to hear it. Thanks.


Hello everyone!

I am having trouble with consistency of spreadsheets across different versions of Excel. I create these gorgeous spreadsheets which are extremely easy on the eyes and very logically set up using the features of Excel 2007, but I am forced to save them in .xls format in order to maintain compatibility across all the un-upgraded desktops in the company I work for. The “ribbon” cruelbar has confounded some members of the staff so much they refuse to EVER upgrade to it--even threatening to quit if they’re forced to comply. So we are stuck for now as a multi-version household.

Problem is my Excel 2007 spreadsheet appearance translates so unpredictably to Excel 2003 it’s ridiculous. Lovely color coordinated works of art look GOD-AWFUL like some kind of Pokemon puke on some people’s machines. The crackheads at MS set up some kind of LSD-Optimized color translation system. I’m having to send people colorless NO-fill worksheets to ensure they don’t get hot magenta cells with lime green text or black on black with black borders (and no, nobody knows how to adjust their own colors, they cry to the boss and send the “unusable” spreadsheets back)..

I have no idea how I can check to see what my spreadsheets are going to look like in 2003 without running Excel 2003 locally. Our techs will not allow us to install both 2003 and 2007 on a single machine due to add-in/plug-in instability, so I can’t run 2003 on the side. Saving for 97-2003 compatibility and re-opening in 2007 doesn't give me any crazy results.

What can I do to ensure color compatibility or even just preview a document in the 2003 format?

--Armand


I created a simple spreadsheet in excel 2007 and tried to save it as excel 2003. Received minor compatibility message. When I 'continued' it returned to portrait and lost the footer containing page number. Why does this happen and what can I do about it?


I tried searching for this but couldn't find anything so maybe I have an isolated issue. I have a user that will run excel 2007 in compatibility mode and when he makes ANY formatting change, e.g. changes a cell using standard colors, and saves he will lose all formatting in the workbook.

The workbook is default save as 97-2003 file type and the workbook was opened in compatibility mode. Microsoft's website claims that all 2007 functionality is disabled when the file is run in compatibility mode, but this seems like the opposite.

Anyone know or heard of anything like this?


Spiike


I am using 2007, I am trying to create a "report" spreadsheet that has only some of the tabs of the original spreadsheet. I can get the new spreadsheet created and added and initially save (empty). However when I copy over the tabs and try to save it I get a compatibility error.


"Some cells or styles in this workbook contain formatting that is not supported by the selected file format. These formats will be converted to the closest format avalible."

I have tried to save the spreadsheet with both .xls and .xlsx


Hi
I have been building a spreadsheet for some weeks now in MSOffice 2007 in collaboration with a colleague. If I make changes and save it in 'Save As 97-2003 compatibility mode' it saves no problem and is openable subsequently.
However, if I make a few minor changes and hit the close 'X' it doesn't ask me if I want to save - odd. Then, with no file apparantly open, if I then try to shut down Excel I am asked if I want to save my document (which must have gone 'invisible' I guess). If I say 'yes' then the document is saved but is subsequently unopenable (Excel runs but no sign of the spreadsheet itself).
I have hunted and killed duff references, dead defined names and links to other documents that aren't on my PC but still the problem persists.
Any ideas, its driving me nuts!
Thanks, Mark.


Hi People!

I have been working on a spreadsheet at work, using Excel '97. Because I am a geeky type, I emailed this to my home email to work on over the weekend. I have Excel 2007 on my home pc. I did my extra work, and come Monday I emailed the updated spreadsheet back to work.

For some reason, although I send the updated version from home, an old version arrives at work. 2007 mentions a compatibility issue (apparently there are some cells referenced out of range of 97) but this should not affect functionality. The document is saved in compatibility mode etc.

Is it possible that 2007 might ignore updates to the file because of the compatibility issue, displaying one version in 2007 and another in 97? I seem powerless to stop the conversion from current to outdated file somewhere between my pc and my work pc. I am at a loss, and baulk at the thought that my reams of work will be only accessible at home, where they cannot be used.

Any help or ideas will be very gratefully received!


I would like to make Excel 2007 default save to .xls (ie use compatibility mode) unless user decides to save as .xlsx. Anyone know how to do this?

thanks!!


In our environment we have Office 2007 with the compatibility pack (added when we were still in Office 2003) and have chosen to have the default save as 97-2003.

I have a user who created an Excel 2007 spreadsheet with a normal embedded chart in a sheet and saves using the default (Excel 97-2003). When he sends it to people on Office 2003, the chart in Excel 2003 comes over as a picture and if that user tries to import the file to extract data it looks like HTML or XML - not usuable. Went to run Compatibility checker in Excel 2007 and it was grayed-out. Seems like a compatibility issue. How do I remedy?


P.S.: to check this you will probably need access to Excel 2007 and Excel 2003


Compatibility mode, in 2007, is frustrating me like crazy. I thought it was supposed to 'limit' functionality to what was in 2003. But what it seems to be doing is letting me use features that only work in 2007and then tell me when I save that 'hey, these won't work after you save'. Ugh! I can't even pick a highlight color without getting a warning and wondering what it will look like to 2003 users!

Is there a 'theme' or anything that will truly limit the features I use to those available to 2003 users?

Thanks in advance,
Drew

I'm new to Excel. I use Excel 2007 on a Win XP machine. Forgive me if my question/ explanation seems confusing but, to be fair, I'm confused myself.

I'm using Excel 2007 to open an Excel 2003 workbook (therefore I'm running in compatibility mode).

I'm able to open the workbook, add or modify data and save the workbook -however I can ONLY save the workbook by using the original file name and over-writing the original file.

I've tried to use the "save as" command to give the workbook a different name but nothing happens. I've even tried to create a new workbook and copy sheets from the Excel 2003 workbook into it and save it with a different name but the file won't save unless I use the original file name.

I'm not sure what I'm doing wrong. Any solutions?

Thanks in advance for your help.


I recently upgraded to Excel 2007 and let me just say it has been a very challenging experience. Anyway... I am having an issue with Excel 2007 getting rid of formulas that are in the Analysis Toolpak (XIRR, XNPV, EOMONTH) when I try to save a file as "97-2003" version. I need to be able to save such files as 97-2003 version so that other people can open my files. However, Excel 2007 keeps on removing the XIRR, XNPV, EOMONTH formulas. Does anyone know of a solution for this?


I'm new to Excel. I use Excel 2007 on a Win XP machine. Forgive me if my question/ explanation seems confusing but, to be fair, I'm confused myself.

I'm using Excel 2007 to open an Excel 2003 workbook (therefore I'm running in compatibility mode).

I'm able to open the workbook, add or modify data and save the workbook -however I can ONLY save the workbook by using the original file name and over-writing the original file.

I've tried to use the "save as" command to give the workbook a different name but nothing happens. I've even tried to create a new workbook and copy sheets from the Excel 2003 workbook into it and save it with a different name but the file won't save unless I use the original file name.

I'm not sure what I'm doing wrong. Any solutions?

Thanks in advance for your help.


I run xl2007 ONLY in my office. A client needed some additional work done on a file (with Macros) created solely in xl2003 (abc.xls). They e-mailed me the file and I performed the changes. The file when opened by me (in xl2007) read Compatibility Mode in the FileName header all the time I was working with it.
When I saved the file (as File type Excel 2003 wb) - (r-abc-xls) the compatibility-checker came up indicating:
The PT in this wb is built in the current file format and will not work in earlier versions of Excel. Only PT's that are created in Compatibility Mode will work in earlier versions of Excel.
I clicked "Continue" and Saved as .xls (2003 file type).

At the office, they loaded "r-abc-xls" and ran the single macro (invovling the only PT) and they got a R/T 1004 message:

This PT was created in a later version of Excel and cannot be updated in this version. To update it, click OK and then open the wb in the version of Excel it was originally created in. grrrr

Any clues as to the direction to go?

Thanks in advance,

Jim


Good Morning,

Recently upgraded to 07 even though I hate the Ribbon

And having a problem with the Compatibility checker. I open a file created in 03 in compatibility mode, Save without making any changes and 07 throws up some incompatibility issues, being data outside of 2003 worksheet range.

I then click find and it takes me to Cell A1. I have checked for named ranges, of which there are non.

any ideas?

/Comfy


Hi All

User edits a spreadsheet. They save the changes/new entries. Close excel. The spreadsheets' modified time-stamp is updated; showing time of save.

When the spreadsheet is next opened. The updates are not present, it's as if the changes have not been saved.

It is intermittent, at first I thought it was user-error, but it's being happening for a couple of months now, different users, different machines. Excel 2003, Windows XP. All updated. Security permissions are correct.

No error messages/warnings, nothing in event logs. Spreadsheets are stored on a networked 2003 SBS file-server. I enabled auditing on the file-server, I can see the three audit entries for the file save process.

First one is writing of a random alphanumeric filename (which I recognise as excels temp file for editing)
Second one is a deletion of "original filename.xls~random alpha-numeric characters.TMP" (don't know if this is a backup/autosave/whatever)
Third one is writing "original filename.xls" (which I would take to be the updated spreadsheet being written)

All entries are successful there are no failure entries. There is nothing else in the log to indicate why the problem exists.

I'm at a complete loss, don't know where to start. ANY Help is greatly appreciated as this has a big effect on productivity when it occurs.

Apologies if this post isn't suitable for this forum.


Hello,
I have a Workbook written in Mac Excel 2008. My distribution must include users of older PC and Mac versions.
The workbook contains several PasteSpecial>Link operations from other Workbooks. It also contains nested IF and other nested functions. One nested IF is a conversion from letter score A-J to number score 1-10. I mention this one because after adding this one I could no longer save as .xls (error msg "will loose some of the functions... etc", and then Excel "quits unexpectedly".
My 2 PCs in the house have Excel 2007 and 2003 and will not open .xlsx.

Question.....
1. Should my 2 PCs be able to open .xlsx? The system with 2007 is supposedly updated automatically, as is the Mac.
2. What ver must I save in to allow widest back compatibility?

Thanks much for help
phstol


I created a spreadsheet using Office 2007 and during the creation of this document I added colour to some of the rows. I have the program defaulted to save as Excel 97 - 2003. I did not realize at the time you could not add colour in that version. I assume the screen posted below is a warning you can not do what I did but is there a way to reverse it?

I have searched the help to see if there was a way to recover the original spreadsheet but I could not find instructions on how to do it. I did find something titled in the help section under compatibility checker but in the example there is a fix command but in the one that comes up on my computer, there is not a fix command.

When I saved it I got a screen that gave me a compatibility report and it said:

Compatibility Report for Master Material List.xls



Run on 4/25/2009 19:28








The following features in this workbook are not supported by earlier versions of Excel. These features may be lost or degraded when you save this workbook in an earlier file format.








Minor loss of fidelity

# of occurrences





Some cells or styles in this workbook contain formatting that is not supported by the selected file format. These formats will be converted to the closest format available.



11
Any assistance would be greatly appreciated

rotcart