Linking to individual Excel worksheets

A

AL

I am am currently linking to excell workbooks from a presentation using
Insert-Object-Current File with the linking option selected to display
updated graphs on powerpoint presentation given through out the month.
However this option only seems to link to the workbook itself. Is there a
way to link to a specific tab with in the workbook?

Thanks.
 
M

Mark

I am am currently linking to excell workbooks from a presentation using
Insert-Object-Current File with the linking option selected to display
updated graphs on powerpoint presentation given through out the month.  
However this option only seems to link to the workbook itself.  Is there a
way to link to a specific tab with in the workbook?

Thanks.

Do you mean to display a tab in PPT, or do you want to open the
workbook in Excel onto that tab?

I'm not sure if there's a way to do this in the interface, but you can
do it via VBA.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top