Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.setup
external usenet poster
 
Posts: 8
Default Unable to open a 82 KB XLSM file due to "Too many different cellformats" & "Converter failed to open the file." errors.

Hello.

I received a 82 KB XLSM (macro version?) file from a colleague. I tried
to open it in my updated (as of last Tuesday) MS Office 2003 Pro. SP3,
with its compatibilty pack. Excel Office SP3 (v11.8302.8221 SP3) failed
to open it.

When opening it, I saw "File conversion in progress" dialog box for a
second, "Too many different cell formats" twice, and then "Converter
failed to open the file."

I asked another co-worker who had old Office 2003 (not updated) and the
compatbility pack. She got the same errors BUT was able to see the read
the contents unlike me.

I read http://support.microsoft.com/kb/213904 and it said there might be
too much 4,000 different combinations of cell formats: "This problem
occurs when the workbook contains more than approximately 4,000
different combinations of cell formats. A combination is defined as a
unique set of formatting elements that are applied to a cell. A
combination includes all font formatting (for example: typeface, font
size, italic, bold, and underline), borders (for example: location,
weight, and color), cell patterns, number formatting, alignment, and
cell protection."

I did find a way to open it. OpenOffice v3.0.1's Calc was able to open
and render it. It did get stuck for a minute when opening (not
responding too).

I can't share this file in public for security reasons. Thank you in
advance. :)
--
Phillip Pi
Senior Software Quality Assurance Analyst
Partner Engineering/Internet Service Provider/Symantec Online Services,
Consumer Business Unit
Symantec Corporation
www.symantec.com
-----------------------------------------------------
Email: YMC (remove SYMC to reply by e-mail)
-----------------------------------------------------
Please do NOT e-mail me for technical support. DISCLAIMER: The views
expressed in this posting are mine, and do not necessarily reflect the
views of my employer. Thank you.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Unable to open a 82 KB XLSM file due to "Too many different cellformats" & "Converter failed to open the file." errors. Phillip Pi Excel Discussion (Misc queries) 0 April 23rd 09 08:53 PM
Lost "File Menu" - now it's "Edit / View / Insert.." but no "F daves Excel Discussion (Misc queries) 3 April 24th 07 04:52 AM
linked PDF will not open "can not open specified file" is message DaveKC Excel Discussion (Misc queries) 0 February 19th 07 07:38 PM
"Cannot access read-only document" (I get this error when I try to open an Excel file) [email protected] Excel Discussion (Misc queries) 1 June 5th 06 01:15 PM
"Cannot access read-only document" (I get this error when I try to open an Excel file) [email protected] Setting up and Configuration of Excel 1 June 5th 06 01:15 PM


All times are GMT +1. The time now is 12:27 AM.

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

About Us

"It's about Microsoft Excel"