Linking to individual Excel worksheets

  • Thread starter Thread starter AL
  • Start date Start date
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.
 
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.
Click to expand...

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.
 
Back
Top