How to automatically update Excel linked in powerpoint?
I have somes excel 2003 tables inside a powerpoint 2003 slides. This Excel has links to others excel files like
[File2.xls]RevenueSheet!$A$1
So, when i change the value of A1 cell in "File2" workbook, i would like the excel sheet inside powerpoint automatically update its value.
But it only happens if i 'double-click' on embeeded excel (in powerpoint) then click outside. Any idea to do this WITHOUT double click ? Maybe using VBA ?
Thanks
I have somes excel 2003 tables inside a powerpoint 2003 slides. This Excel has links to others excel files like
[File2.xls]RevenueSheet!$A$1
So, when i change the value of A1 cell in "File2" workbook, i would like the excel sheet inside powerpoint automatically update its value.
But it only happens if i 'double-click' on embeeded excel (in powerpoint) then click outside. Any idea to do this WITHOUT double click ? Maybe using VBA ?
Thanks
No comments:
Post a Comment