some text formatting may have changed in this file because the max

[peng peng]

when i open a worksheet, the dialog box always open,it says:

some text formatting may have changed in this file because the maximum
number of fonts was exceeded, it may help to close other documents and try
again.

I dont know what makes this dialog always open along with worksheet, and how
to fix this problem.

 

[Tausif]

Hi,

Have you tried Copy/pasting the data to a new workbook ?

You may also want to copy the entire worksheet(s) to a new workbook .

Hopefully that might eliminate the problem.

Cheers,

 

[peng peng]

Thank you Tausif,

yes I do these actions every day , so what should I do to avoid this dialog ?