Excel crash, "Too many different cell formats"


R

R Torbert

How do I recover my Excel file? When I try to open, I
get, "Too many different cell formats".
 
Ad

Advertisements

P

Philipp von Wartburg

Hi

If the file opens (after closing the error message),
reduce the number of different cell formats. Here you find
a detailed description, many tips and hints (in german):
http://195.186.84.74/xlimits/xllimit6.htm

There is an Excel add-in called "Cell Format Counter". It
helps you to find out, how many cell formats are used,
available and allowed in a workbook. Here is the
description of the add-in:
http://195.186.84.74/products/cefa-
toolbox/cellformatcounter.htm
Download of the add-in:
http://195.186.84.74/download/tools/CellFormatCounter.zip

If the Excel file does not open after closing the error
message, IMHO there's no way to recover the file. But you
can try a recovery/repair tool. Here is a list:
http://195.186.84.74/soscq/datenretten.htm#Tools

Regards
Philipp

¦¦¦ xlam - Excel and more!
¦¦¦ http://195.186.84.74/index.htm
 
Ad

Advertisements

S

SidBord

Regardiing recovering your crashed workbook (assumming you
don't create backups), I recently had to reover a trashed
workbook. I created a new workbook and linked cells from
the new workbook to the equivalent cells in the broken
workbook. You don't have to open the broken workbook for
this to work. I had some cleaning up to do, but most of my
data was recovered. I can't remember the exact syntax of
the formulas to use, but it was something like:
='C:\[BrokenWB.xls]SheetName1'!A1, etc.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top