It sounds to me that the workbook (or maybe a specific worksheet in that
workbook) is close to being corrupted.

Maybe rebuilding that worksheet (or the whole workbook) would be in order.

You may want to try OpenOffice. Open your workbook in that, save it (as an
excel file) and see if that help cleans up your problem in excel.

http://www.openoffice.org, a 60-104 meg download or a CD

wrote:

I have a workbook created from a macro that recently started to post
the following message ONLY when first opened:

"Excel encountered an error and had to remove some formatting to avoid
corrupting the workbook. Please re-check your formatting carefully"

I've searched the groups and the 'net and unfortunately have not found
much helpful information. If I open the file, save it, then open it
again it won't return the above message again. I wrote code to open
the file and save it, in essence trying to by-pass the error message,
but it still appeared. Does anyone have any suggestions?!?!?

Thanks in advance!!!

Brian

--

Dave Peterson