ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   some text formatting may have changed in this file because the max (https://www.excelbanter.com/excel-discussion-misc-queries/195909-some-text-formatting-may-have-changed-file-because-max.html)

peng peng

some text formatting may have changed in this file because the max
 
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

some text formatting may have changed in this file because the max
 
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,
--
Tausif Mohammed


"peng peng" wrote:

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.







peng peng[_2_]

some text formatting may have changed in this file because the
 
Thank you Tausif,

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

"Tausif" wrote:

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,
--
Tausif Mohammed


"peng peng" wrote:

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.








All times are GMT +1. The time now is 09:36 AM.

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