W
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!
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!