Al
This KB Article addresses this issue.
http://support.microsoft.com/default...b;en-us;213904
Note: article points out "about 4000" different formats as the limit and makes
suggestions for reducing.
Gord Dibben Excel MVP
On Mon, 16 Feb 2004 16:31:05 -0800, "AgLem"
wrote:
Howdy All,
I'm receiving an error when i am copying sheets into a workbook.
What happens is, we have around 200 workbooks each containing one sheet.
This sheet contains a small amount of data. The only formatting on the sheet is font, font size, and borders.
The macro i have, copies via paste-specialvalues the contents of each workbook to a new sheet , in one central workbook.
I have also tried just copying the sheet itself.
However after copying a around 20/30 sheets it errors out saying "Too many cell formats".
I'm getting frustrated as i've seen other workbooks, with hundreds of pages with formatting galor, that easily outnumbers the megar formatting i have in my workbooks.
Does anyone know of a way around this problem?
Thanks and cheers.
AL