I have a spreadsheet with tables and graphs and would like to send them out
so that people get the data but not all the formulae, and get the data as it
is when I send the spreadsheet out.

Is there any easy way to copy and special the whole lot? So far I can only
copy and paste special values on the tables. The graphs do not get copied and
when I copy them seperately they remain linked to the original.

Any suggestions would be great.
Thanks!

Hi,

Have a read of Jon Peltier's page on the matter.
http://peltiertech.com/Excel/ChartsH...ChartData.html

Cheers
Andy

Light wrote:
I have a spreadsheet with tables and graphs and would like to send them out
so that people get the data but not all the formulae, and get the data as it
is when I send the spreadsheet out.

Is there any easy way to copy and special the whole lot? So far I can only
copy and paste special values on the tables. The graphs do not get copied and
when I copy them seperately they remain linked to the original.

Any suggestions would be great.
Thanks!

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Or copy the chart as a picture (Shift + Edit menu Copy Picture, use On
Screen and Picture options) and paste it into the copied sheet.

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


"Andy Pope" wrote in message
...
Hi,

Have a read of Jon Peltier's page on the matter.
http://peltiertech.com/Excel/ChartsH...ChartData.html

Cheers
Andy

Light wrote:
I have a spreadsheet with tables and graphs and would like to send them
out so that people get the data but not all the formulae, and get the
data as it is when I send the spreadsheet out.

Is there any easy way to copy and special the whole lot? So far I can
only copy and paste special values on the tables. The graphs do not get
copied and when I copy them seperately they remain linked to the
original. Any suggestions would be great. Thanks!

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info