Graphs creating huge file size

[WBTKbeezy]

Hello:

I have a workbook with a lot of data that (using a looping macro) we create
1200+ separate workbooks using 4 tabs from the original workbook. I am
running into an issue now that on one of the tabs that is copied over to the
new workbook we include a graph. When I go to create one of the smaller
workbooks, the file size has jumped from 300K to 10MB. I looked through and
found that including a graph has brought over references to EVERY named range
in the original workbook which are now external references (though only 4
named ranges should be in the newly created books.) If I remove the graph and
re-run, the file size goes back to 300K and no external named ranges are
referenced. Does anyone know the reason for this or how I can include the
graph WITHOUT copying the named ranges over?

Thanks!

 

[Jon Peltier]

Either the names are referenced by formulas in the copied worksheet, or they
are defined as ranges on this worksheet.

- Jon

 

[WBTKbeezy]

As I worked through troubleshooting, I found that when the graph was NOT
included, the external named ranges do not get referenced in the copied sheet
(and the file size is dramatically smaller). I even tried inserting a blank
graph with NO references to anything (it basically looked like an empty text
box) and the named range references came with the copied sheet (and the file
size was over 10MB). (There are about - 50 named ranges)... Any thoughts?

 

[Jon Peltier]

I tried duplicating your issue, and could not. What version of Excel are you
using?

- Jon

 

[WBTKbeezy]

I am using Excel 2003 (SP2). If there is other information I could give you
please let me know...