What's in the report worksheets that you don't want to retain? The
process of going through the charts and parsing what is and isn't source
data is long and tortuous. I stick with my earlier suggestion to save a
copy of the original workbook. Alternatively, make the macro that builds
the report workbook build a slimmed down version with just the data and
charts.

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


hong wrote:

Could anybody help me out? Thanks!