Re: Too many different cell formats

From: Dave Peterson (ec35720_at_msn.com)
Date: 02/19/04 

Date: Wed, 18 Feb 2004 21:30:52 -0600

See one reply at your first post.

Mike wrote:
>
> Recently, while working with a large Excel 2000 workbook,
> I encountered an error. The error read "Too many
> different cell formats." After clicking "OK" I saved and
> closed the workbook.
>
> Unfortunately, now, my workbook will not open!!!
> Microsoft's fix posted on their website is to reduce the
> file formats in the workbook. However, once you've closed
> the workbook, it is impossible to open it again.
>
> Does anyone know of a fix for this problem. My last
> backup file is over two weeks old!!!
>
> Thanks,
>
> Mike 

-- 
Dave Peterson
ec35720@msn.com

Relevant Pages

  • RE: Four User Defined Functions - probably one similar answer
    ... This is for Excel 2003 and you must be in the workbook where the macro is ... "Mike H" wrote: ... Right click 'This Workbook' and insert module. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Application.Quit
    ... I am running on Excel 2003, ... "Mike H" wrote: ... of ActiveWorkbook to narrow it down to the workbook containing the macro. ... (Until I close and Open Excel again). ...
    (microsoft.public.excel.programming)
  • Re: How do I set up incremental numbering of Invoices in Excel?
    ... I was a bit hasty with my follow up to your suggestion Mike, ... How can this be done in Excel? ... This will bring up a second window called the ... > them will be VBAProject (Your workbook name). ...
    (microsoft.public.excel.programming)
  • Re: formula to remove formula???
    ... Hope it works for Mike ... I took Gord's basic code and added some stuff to it that will determine the ... I have a workbook that gathers daily work hours and OT hours for my ... Or have the formula call a macro to copy/paste special in the active cell? ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Pop up Calendar in a distributed workbook
    ... Mike, have a look here and see if this will work for you ... Always backup your data before trying something new ... > a workbook that I want to have available to several users. ... Most users will be using Excel 97 ...
    (microsoft.public.excel.misc)