Hello,

I have excel file.
in the excel there is three sheets:
test1, test2 and test3.
in the test1 sheet I have chart with parameters.
when I copy the chart and the parameters in the sheet 'test1' to powerpoint
(with past special) and choose the 'microsoft excel chart object' it past the
chart to powerpoint and I can change the parameters inside but the problem is
that it also copy the other two sheets: test2 and test3.
I want when I copy the excel chart to powerpoint that it will copy only the
test1 sheet (without the test2 and test3 sheets), because this is what I
marked.

please help me,

Evyatar

The "Excel Object" is the workbook not the worksheet. So all worksheets are
available from the PowerPoint doc
If you just do a Paste (not Paste Special) and specify linked then the chart
in the PPT will get changed when the chart is changed (provided the workbook
stays in the same folder) in Excel but the user cannot access the workbook
from PowerPoint
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"?????" wrote in message
...
Hello,

I have excel file.
in the excel there is three sheets:
test1, test2 and test3.
in the test1 sheet I have chart with parameters.
when I copy the chart and the parameters in the sheet 'test1' to
powerpoint
(with past special) and choose the 'microsoft excel chart object' it past
the
chart to powerpoint and I can change the parameters inside but the problem
is
that it also copy the other two sheets: test2 and test3.
I want when I copy the excel chart to powerpoint that it will copy only
the
test1 sheet (without the test2 and test3 sheets), because this is what I
marked.

please help me,

Evyatar