ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   TOO MANY DIFFRENT CELL FORMAT (https://www.excelbanter.com/excel-discussion-misc-queries/215724-too-many-diffrent-cell-format.html)

Raz

TOO MANY DIFFRENT CELL FORMAT
 
I am material planner, so easy to do my work i create formula at Excel 2003
and link (1 file- 41 sheet, 2.8 KB) and (1 file-14 sheet, 500 KB) together..
my problem is file for 2.8 KB everytime i am want do something adjustment @
edit, it always show "TOO MANY DIFFRENT CELL FORMATS" error.so this area i
cannot do anything.. Is that any limit for worksheet in 1 file? so how to
settled my prblm and any suggestion.

--
Raz

Dave Peterson

TOO MANY DIFFRENT CELL FORMAT
 
XL: Error Message: Too Many Different Cell Formats
http://support.microsoft.com/default.aspx?scid=213904

Will explain the problem.

Try to use fewer formats.

Raz wrote:

I am material planner, so easy to do my work i create formula at Excel 2003
and link (1 file- 41 sheet, 2.8 KB) and (1 file-14 sheet, 500 KB) together..
my problem is file for 2.8 KB everytime i am want do something adjustment @
edit, it always show "TOO MANY DIFFRENT CELL FORMATS" error.so this area i
cannot do anything.. Is that any limit for worksheet in 1 file? so how to
settled my prblm and any suggestion.

--
Raz


--

Dave Peterson

Shane Devenshire[_2_]

TOO MANY DIFFRENT CELL FORMAT
 
Hi,

You can also look in the Excel Help under the topic "Specifications"

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Dave Peterson" wrote:

XL: Error Message: Too Many Different Cell Formats
http://support.microsoft.com/default.aspx?scid=213904

Will explain the problem.

Try to use fewer formats.

Raz wrote:

I am material planner, so easy to do my work i create formula at Excel 2003
and link (1 file- 41 sheet, 2.8 KB) and (1 file-14 sheet, 500 KB) together..
my problem is file for 2.8 KB everytime i am want do something adjustment @
edit, it always show "TOO MANY DIFFRENT CELL FORMATS" error.so this area i
cannot do anything.. Is that any limit for worksheet in 1 file? so how to
settled my prblm and any suggestion.

--
Raz


--

Dave Peterson



All times are GMT +1. The time now is 04:29 AM.

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