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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"WBTKbeezy" wrote in message
...
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!