View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Greg Lovern Greg Lovern is offline
external usenet poster
 
Posts: 224
Default "Excel encountered an error and had to remove some formatting toavoid corrupting the workbook. Please re-check your formatting carefully."

We have workbooks that are passed around many users around the world
using four different languages, with more languages to come. We're
consistently getting the following error:

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

The error happens consistently under the following circumstances:

-- A user of English Excel 2007 opens a workbook that was saved by a
user of Japanese Excel 2007.
-- A user of German Excel 2007 opens a workbook that was saved by a
user of English Excel 2007.

Of course, in the latter case, the error message is in German.

In all cases, we just click OK, then save the workbook, and the error
does not return until either of the steps above are repeated.

What exactly is being removed? Users are asking me, and I have no
idea. We don't see any difference in the files after it happens; all
visible formatting appears to be unchanged. Any thoughts?


Thanks,

Greg