View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Don Wiss Don Wiss is offline
external usenet poster
 
Posts: 300
Default File error. Some number formats may have been lost.

I'm in the middle of getting my xl 2002 workbooks to also work under xl
2000. The company we are buying overnighted to me a PC with xl 2000.

One problem I'm getting is on one very large workbook Excel is giving me a
"File error. Some number formats may have been lost." upon startup. I did
some google searching and I find that others have gotten this when mailing
a 2002 workbook to a 2000 user. Some mention the workbook being corrupted.
Unlikely. Then I saw some messages about having too many custom formats. If
this is so, then I can delete the numerous unused ones listed. But nothing
I found gave any definitive answer. Any ideas?

One idea I have is to write a program that extracts all the formats and
puts them into a workbook as strings. Run on each system, then compare
those two workbooks. (The xl 2000 PC was connected to our network.)

Don <www.donwiss.com (e-mail link at home page bottom).