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.

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.

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.

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 -

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 -

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 -