Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel Limitations
when copying worksheets why do I get 'no more fonts can be added' message
|
#2
|
|||
|
|||
Excel has a limit of 4,000 unique fonts per file
unfortunately it also can "remember" some of the charts you create then delete. making it easier to hit the 4,000 limit you may need to copy information to a new file "JAKOMO" wrote: when copying worksheets why do I get 'no more fonts can be added' message |
#3
|
|||
|
|||
Thank you,
But, just to be clear, I built one worksheet (wtih three graphs) and copied it 50 times. I started getting the message around sheet 30. Are you saying I should copy all the worksheets to a new workbook? I have already renamed the workbook. "Vacation's Over" wrote: Excel has a limit of 4,000 unique fonts per file unfortunately it also can "remember" some of the charts you create then delete. making it easier to hit the 4,000 limit you may need to copy information to a new file "JAKOMO" wrote: when copying worksheets why do I get 'no more fonts can be added' message |
#4
|
|||
|
|||
30 times 3 = 90 graphs which means that Excel "thinks' tehre are over 100
"fonts" per graph. More likely when you made 3 graphs you experimented on that page, Excel may remember the experiments and copy to new sheets. My aproach was to take the original 3 graphs and copy to a new file, then replicate to sheets in new file. This can happen alot. One way out is to reevaluate WHY you want 50 sheets with the same Graphs9i assume different data), but Couldn't you use macros to shift data selections and have data and graphs on one or two sheets? "JAKOMO" wrote: Thank you, But, just to be clear, I built one worksheet (wtih three graphs) and copied it 50 times. I started getting the message around sheet 30. Are you saying I should copy all the worksheets to a new workbook? I have already renamed the workbook. "Vacation's Over" wrote: Excel has a limit of 4,000 unique fonts per file unfortunately it also can "remember" some of the charts you create then delete. making it easier to hit the 4,000 limit you may need to copy information to a new file "JAKOMO" wrote: when copying worksheets why do I get 'no more fonts can be added' message |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do I find a file/spreadsheet that Excel says is Already open but I can't find it? | Excel Discussion (Misc queries) | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel |