I
Israel
I use Excel 2002 SP3.
In one particular .xls workbook (744 KB) - which contains data starting in
1978 - I have about 26 sheets, some of which include significant formating,
mainly borders, number, currency and coloring and is in constant use.
As of the last few months, when attempting many operations in various sheets
(apparently in random cells but not in others) I get a box saying: "Too many
different cell formats" and I am unable to perform the operation. The problem
operations are not necessarily format related.
How can I solve this so as to permit smoothly continuing to work with this
..xls sheet.
Thanks in advance
In one particular .xls workbook (744 KB) - which contains data starting in
1978 - I have about 26 sheets, some of which include significant formating,
mainly borders, number, currency and coloring and is in constant use.
As of the last few months, when attempting many operations in various sheets
(apparently in random cells but not in others) I get a box saying: "Too many
different cell formats" and I am unable to perform the operation. The problem
operations are not necessarily format related.
How can I solve this so as to permit smoothly continuing to work with this
..xls sheet.
Thanks in advance