B
Brian McB
I am attempting to feed information from an external excel spreadsheet into
my PowerPoint presentation. I tried originally to "paste special" into the
file and it copied the information as it was when copied, however the
information is dynamic and changes all the time. I then went into "Worksheet
Object > Open" and manually edited each cell to:
= '[myExcel.xls]Sheet1'!$A$1
This showed all the data as it was at that particular moment. I then tried
to edit the Excel file to change the data and looked in the PowerPoint
presentation and no change was made. I tried various methods of having them
both open at the same time, editing the Excel saving then opening PowerPoint
the changes did not show. I was able to get PowerPoint to look for changes
when I selected "Worksheet Object > Open" this action would force PowerPoint
to refresh the data for that object only.
Is there a process / macro / better methodology to setup PowerPoint to use
dynamic data, control the refresh rate or feed live edits from information on
another MS Office product.
Any tips or points in the right direction are greatly appreciated
my PowerPoint presentation. I tried originally to "paste special" into the
file and it copied the information as it was when copied, however the
information is dynamic and changes all the time. I then went into "Worksheet
Object > Open" and manually edited each cell to:
= '[myExcel.xls]Sheet1'!$A$1
This showed all the data as it was at that particular moment. I then tried
to edit the Excel file to change the data and looked in the PowerPoint
presentation and no change was made. I tried various methods of having them
both open at the same time, editing the Excel saving then opening PowerPoint
the changes did not show. I was able to get PowerPoint to look for changes
when I selected "Worksheet Object > Open" this action would force PowerPoint
to refresh the data for that object only.
Is there a process / macro / better methodology to setup PowerPoint to use
dynamic data, control the refresh rate or feed live edits from information on
another MS Office product.
Any tips or points in the right direction are greatly appreciated