A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Cannot read Excel 2007 despite installing Compatitibility Pack



 
 
Thread Tools Display Modes
  #1  
Old July 16th, 2008, 06:31 AM posted to microsoft.public.excel.misc
MatthewPollock
external usenet poster
 
Posts: 2
Default Cannot read Excel 2007 despite installing Compatitibility Pack

We were preparing to send to clients a large Excel 2007 worksheet with much
formatting, and many inter-spreadsheet links. We then discovered this
spreadsheet cannot be opened by users with Excel 2003, even if they have
installed the Microsoft Compatibility Pack.

This problem occurs regardless of whether the Excel 2007 file is saved as
xlsx (i.e., in Excel 2007 format), or is converted to xls (Excel 2003
format).

When attempting to open the Excel 2003 file, the following error message is
displayed:

“Too many different cell formats”
“Errors were detected in “GPG – Big Table.xls,” but Microsoft Office Excel
was able to open the file by making the repairs listed below. Save the file
to make these repairs permanent.”
“Damage to the file was so extensive that repairs were not possible. Excel
attempted to recover your formulas and values, but some data may have been
lost or corrupted.”

In reality, all the formatting has been lost, as have the inter-spreadsheet
links, so that the Excel worksheet is unusable.

When attempting to open the Excel 2007 file, the system prompts us to save
it as an Excel 2003 file, and the above is repeated:

What can we do? We cannot send to clients an Excel 2007 spreadsheet if it
cannot be used by clients who only have Excel 2003. Starting afresh by
inputting the data into Excel 2003 will take a long time. What is the
solution?


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 05:16 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 OfficeFrustration.
The comments are property of their posters.