What causes file-level corruption and individual cell CF rule corruption? (i.e. What is the most efficient and effective approach to duplicate the CF rules in the new workbook (without transferring corrupt contents)?Ģ. I use "Copy & Paste" as the transfer mechanism within the macro, I'm concerned that the corruption may be transferred to the new workbook. I can create macros to copy cell formulas and named ranges, but copying the conditional formatting rules is problematic. The safest approach (I think) is to start with a blank workbook and duplicate the contents of the corrupt file's cells. When I save and close the repaired file, some cells' However, it's impossible to determine the extent and location of every repair. Some of the "repaired" cells have lost all of their formatting, while some CF rules have been deleted. Parts of this workbook may have been repaired or discarded." The log indicates: I've used Excel's "Open and Repair" feature and received the generic response: "Excel completed file level validation and repair. The corruption can be seen in many erroneously formatted cells in several of the worksheets.
The file is 6 MB, contains 35 worksheets, 500 named ranges, 400k cells with formulas, 50k formatted cells, 2k cells with uniqueĬonditional formatting (CF) rules, as well as macros and user forms. I have a corrupt Excel 2010 macro-enabled workbook (Win 7) that was originally created using Excel 2006 many years ago.
0 kommentar(er)
