too many different cell formats?

G

Guest

Our company has a file, which we share internally to update any changes that
is being made to an on-going project. The updates are made hourly or more
often and we started to see error messages that read "too many different cell
formats".

Then this morning, I got a new message that read..."Errors were detected in
file '\\Server\poi\PROJECT\04C20(03R12) Pumyang BR\04C20 Master.xls' The
following is a list of repairs: 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."

I am able to open the excel file, except, all of the formats are deleted.
The formats that we had on the file is crucial and we need to recover this.
Please let me know if there is a way to recover this. Thank you.
 
F

Franz Verga

jh1 said:
Our company has a file, which we share internally to update any
changes that is being made to an on-going project. The updates are
made hourly or more often and we started to see error messages that
read "too many different cell formats".

Then this morning, I got a new message that read..."Errors were
detected in file '\\Server\poi\PROJECT\04C20(03R12) Pumyang BR\04C20
Master.xls' The following is a list of repairs: 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."

I am able to open the excel file, except, all of the formats are
deleted. The formats that we had on the file is crucial and we need
to recover this. Please let me know if there is a way to recover
this. Thank you.


AFAIK there's no way to recover these format.

About the error message "too many different cell formats" I think this could
be useful for you:

http://support.microsoft.com/kb/213904/en-us

http://exceltips.vitalnews.com/Pages/T0213_No_More_Custom_Formats_Can_Be_Added.html


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy
 

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