no more new fonts may be applied in this workbook

alanjleib · Apr 3rd, 2002, 11:36 AM

I have a large spreadsheet that collects some data and and creats graphs.Whe trying to add data I get a window that displays....
"no more new fonts may be applied in this workbook" I can then "ok" the window many times and it will work. It also affects cutting and pasting and linking.

Any ideas?
Thanks

kmiles · Apr 3rd, 2002, 11:55 AM

create a macro that selects all cells, then sets the font the same for all.

Anne Troy · Apr 3rd, 2002, 12:32 PM

Well you don't really need a macro to do that. You can just hit ctrl-a, and apply one font style and size, non-bold, non-italic, all one color.

Then, in the largest groups possible, format your bolds, colors, etc.

This occurs because the person using the workbook formats cells one at a time instead of entire rows or columns at a time.

Apr 3rd, 2002, 12:32 PM	#3
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	Well you don't really need a macro to do that. You can just hit ctrl-a, and apply one font style and size, non-bold, non-italic, all one color. Then, in the largest groups possible, format your bolds, colors, etc. This occurs because the person using the workbook formats cells one at a time instead of entire rows or columns at a time. __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 3rd, 2002, 11:36 AM	#1
alanjleib New Member Join Date: Apr 2002 Posts: 1	I have a large spreadsheet that collects some data and and creats graphs.Whe trying to add data I get a window that displays.... "no more new fonts may be applied in this workbook" I can then "ok" the window many times and it will work. It also affects cutting and pasting and linking. Any ideas? Thanks

Apr 3rd, 2002, 11:55 AM	#2
kmiles Board Regular Join Date: Apr 2002 Posts: 113	create a macro that selects all cells, then sets the font the same for all.