Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Typical Problem
i have a excel file which contains more than 20 work books and each is
interelated with each other. recently when i am adding some comments in one of those sheets i am getting the following message "no more new fonts may be applied in this book" can any one help me out. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Typical Problem
Check out this link:
http://support.microsoft.com/default...b;en-us;213904 XL: Error Message: Too Many Different Cell Formats to explain what's happening and how to get round it. Hope this helps. Pete On Mar 23, 10:04 am, vijaydsk1970 wrote: i have a excel file which contains more than 20 work books and each is interelated with each other. recently when i am adding some comments in one of those sheets i am getting the following message "no more new fonts may be applied in this book" can any one help me out. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Typical Problem
Ok. Pete_UK. I gone through the article.
i checked up the file. But what ever the formats existing in my file needs those formats, i tried to reduce the formats but in vain. is there any way to overcome this problem. "Pete_UK" wrote: Check out this link: http://support.microsoft.com/default...b;en-us;213904 XL: Error Message: Too Many Different Cell Formats to explain what's happening and how to get round it. Hope this helps. Pete On Mar 23, 10:04 am, vijaydsk1970 wrote: i have a excel file which contains more than 20 work books and each is interelated with each other. recently when i am adding some comments in one of those sheets i am getting the following message "no more new fonts may be applied in this book" can any one help me out. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Typical Problem
To quote from the article:
" ... To resolve this problem, simplify the formatting in the workbook ..." If you can't simplify the formatting, then you will be stuck with the problem, as Excel can only handle up to 4000 different format combinations. Pete On Mar 24, 1:21 pm, vijaydsk1970 wrote: Ok. Pete_UK. I gone through the article. i checked up the file. But what ever the formats existing in my file needs those formats, i tried to reduce the formats but in vain. is there any way to overcome this problem. "Pete_UK" wrote: Check out this link: http://support.microsoft.com/default...b;en-us;213904 XL: Error Message: Too Many Different Cell Formats to explain what's happening and how to get round it. Hope this helps. Pete On Mar 23, 10:04 am, vijaydsk1970 wrote: i have a excel file which contains more than 20 work books and each is interelated with each other. recently when i am adding some comments in one of those sheets i am getting the following message "no more new fonts may be applied in this book" can any one help me out.- Hide quoted text - - Show quoted text - |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Typical Problem
Is this problem is appearing in office 2007. can you help me out
Thanks "Pete_UK" wrote: To quote from the article: " ... To resolve this problem, simplify the formatting in the workbook ..." If you can't simplify the formatting, then you will be stuck with the problem, as Excel can only handle up to 4000 different format combinations. Pete On Mar 24, 1:21 pm, vijaydsk1970 wrote: Ok. Pete_UK. I gone through the article. i checked up the file. But what ever the formats existing in my file needs those formats, i tried to reduce the formats but in vain. is there any way to overcome this problem. "Pete_UK" wrote: Check out this link: http://support.microsoft.com/default...b;en-us;213904 XL: Error Message: Too Many Different Cell Formats to explain what's happening and how to get round it. Hope this helps. Pete On Mar 23, 10:04 am, vijaydsk1970 wrote: i have a excel file which contains more than 20 work books and each is interelated with each other. recently when i am adding some comments in one of those sheets i am getting the following message "no more new fonts may be applied in this book" can any one help me out.- Hide quoted text - - Show quoted text - |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Typical Problem
Sorry, I don't have XL2007 - perhaps one of the other regulars can
come in here ... Pete On Mar 24, 5:11 pm, vijaydsk1970 wrote: Is this problem is appearing in office 2007. can you help me out Thanks "Pete_UK" wrote: To quote from the article: " ... To resolve this problem, simplify the formatting in the workbook ..." If you can't simplify the formatting, then you will be stuck with the problem, as Excel can only handle up to 4000 different format combinations. Pete On Mar 24, 1:21 pm, vijaydsk1970 wrote: Ok. Pete_UK. I gone through the article. i checked up the file. But what ever the formats existing in my file needs those formats, i tried to reduce the formats but in vain. is there any way to overcome this problem. "Pete_UK" wrote: Check out this link: http://support.microsoft.com/default...b;en-us;213904 XL: Error Message: Too Many Different Cell Formats to explain what's happening and how to get round it. Hope this helps. Pete On Mar 23, 10:04 am, vijaydsk1970 wrote: i have a excel file which contains more than 20 work books and each is interelated with each other. recently when i am adding some comments in one of those sheets i am getting the following message "no more new fonts may be applied in this book" can any one help me out.- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
my excel is SLOW & "not responding"? typical? anything i can fix? | Excel Discussion (Misc queries) | |||
Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
Typical excel interviewing questions | Excel Discussion (Misc queries) | |||
problem with a conditional max problem | Excel Discussion (Misc queries) |