Office & productivity software: Excel 2007 compatability problems with 2003
Excel 2007 compatability problems with 2003
by jcarithe - 6/1/09 2:13 PMI recently upgraded to Office 2007 but mostly work with folks on 2003. I've had recurring issues when I edit files that were originally created in 2003. Even after only minor changes they lose all formatting when opened as .xls files. I don't think I'm exceeding 4000 formats but based on my research (google) that's what appears to be happening. How can I figure out why, and/or how to fix?
Compatibility mode.
by MarkFlax
- 6/2/09 9:34 AM
In reply to: Excel 2007 compatability problems with 2003 by jcarithe
I'm not clear from your post what problem you are describing.
When you open these (old version) .xls files in Excel 2007, do you see the file name in the Title bar, with (Compatibility Mode)? EG
File name = Summary.xls (Compatibility Mode) Microsoft Excel 2007.
If so, you are working on an Excel 2003 file in Excel 2007's compatibility mode, and anything you do to that file that Excel 2003 cannot handle, (for example colored headers), will be reported when you attempt to re-save the file in the older mode.
There is no way around this, as Excel 2003 and earlier cannot handle the Excel 2007's new features.
Is that what you are describing?
Mark
"they lose all formatting when opened as .xls files"
by R. Proffitt - 6/2/09 11:28 AM
In reply to: Excel 2007 compatability problems with 2003 by jcarithe
Let me share an old issue that dogged us for years. It mainly shows up in Word but has been spotted in Excel. Here's the setup.
1. Your common Word file with fonts, etc.
2. Get a new machine with some Windows that has never had a printer driver installed and there is no default printer.
3. Install Word (only tested this with 95 to 2003.)
4. The formatting vanishes.
I've seen Excel do that.
And in parting, another idea. I occasionally have an user that can't read my new files. If that is so I run up Open Office and try to load the file there. Then I save it from OO and the user gets their file.
Bob
| Forum legend: | |
 |
Locked thread |
 |
Moderator |
 |
CNET staff |
 |
Samsung staff |
 |
Norton Authorized Support team |
 |
AVG staff |
 |
Windows Outreach team |
 |
Dell staff |
 |
Intel staff |
