Graphs creating huge file size
 

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!

Graphs creating huge file size
 

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!

Graphs creating huge file size
 

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" wrote:

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!

Graphs creating huge file size
 

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

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


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

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!

Graphs creating huge file size
 

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

"Jon Peltier" wrote:

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

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


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

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!