E
ETM
Excel 97 SR-2
I am attempting to merge (move/copy) worksheets from multiple workbooks into
one workbook. I am having an issue with one particular workbook
(unfortunately, the primary one).
Whenever I attempt to move or copy a worksheet into or out of this
particular workbook, I receive the following error message:
"Too Many Different Cell Formats".
Then, if I toggle between workbooks, I receive the error message:
"The instruction at "0x3023b43e" referenced memory at "0x0000028c". The
memory could not be read". Click on OK to terminate the program."
I have gone into each workbook and deleted all of the superfluous custom
cell formats that have accumulated over time. The only impact was to change
the first error message from "Too Many Custom Formats" to "Too Many Different
Cell Formats."
I have attempted to minimize the number of different formats, but this has
had no impact.
The problematic workbook is 7465 Kb.
I am able to merge worksheets from other workbooks without issue.
Any suggestions welcome.
I am attempting to merge (move/copy) worksheets from multiple workbooks into
one workbook. I am having an issue with one particular workbook
(unfortunately, the primary one).
Whenever I attempt to move or copy a worksheet into or out of this
particular workbook, I receive the following error message:
"Too Many Different Cell Formats".
Then, if I toggle between workbooks, I receive the error message:
"The instruction at "0x3023b43e" referenced memory at "0x0000028c". The
memory could not be read". Click on OK to terminate the program."
I have gone into each workbook and deleted all of the superfluous custom
cell formats that have accumulated over time. The only impact was to change
the first error message from "Too Many Custom Formats" to "Too Many Different
Cell Formats."
I have attempted to minimize the number of different formats, but this has
had no impact.
The problematic workbook is 7465 Kb.
I am able to merge worksheets from other workbooks without issue.
Any suggestions welcome.