Excel file keeps closing

[Guest]

Hallo

I have an excel document with which a group of people work with; the problem
is that by one or two of the colleagues, when they try to open the document,
excel closes and asks if a report should be sent on to MS. When this document
is not free for all to use at the same time, the problem does not occur!!! I
have tried to copy the worksheets individually into a new Workbook and then
in turn give this workbook "free" however when I tried to copy some of the
sheets, excel showed a message stating that some of the cells had more than
255 characters and that some of the data might be lost. All users can open
this file, however they all receive a warning with regard to formatting which
they can click away.

Has anyone an idea of what I could do here???

Many thanks,

Melvin

 

[Dave Peterson]

I'm guessing that not-Free means that the workbook is shared.

I don't have a guess why excel locks up with a shared workbook--I don't use them
very often.

But when you were recreating the workbooks, you copied the sheet to a new
workbook and got that 255 character warning.

Just go back to the original worksheet, select all the cells (ctrl-a (twice in
xl2003)) and copy|paste right over the newly created sheet. (copying cells will
work ok. Copying worksheets causes the error.)

And maybe for the format portion...

It kind of sounds like you're getting hit with the fact that Excel has a limit
of 4000 different formats in a workbook.

XL: Error Message: Too Many Different Cell Formats
http://support.microsoft.com/?scid=213904