ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   "Excel encountered an error and had to remove some formatting toavoid corrupting the workbook. Please re-check your formatting carefully." (https://www.excelbanter.com/excel-discussion-misc-queries/195452-excel-encountered-error-had-remove-some-formatting-toavoid-corrupting-workbook-please-re-check-your-formatting-carefully.html)

Greg Lovern

"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


All times are GMT +1. The time now is 01:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com