![]() |
#1
|
|||
|
|||
![]()
Hi Friends,
I have to prepare a monthly presentation for my company. I have all financial data in multiple tabs in excel that have been linked to many powerpoint slides. The problem is, I update the same excel sheet every month and save it with a different name. How can I change the source in powerpoint to select and update all the slides with all the corresponding tabs. At present, I use Edit link (ALT+E+K) > Select each slide on the powerpoint> Change source to new excelfile. When I select all the sheets, the "change source" greys out. Hence I have to do it individually. Please help me be more efficient. This is very time consuming. I am sure there is a better option I am not aware about. Using excel and powerpoint 2010 Thanks in advance |
#2
|
|||
|
|||
![]()
As far as I know there's no way in the GUI to do this. If you do this that regularly I would write (or if you can't do it in house, get written) a small add to create a ribbon button to modify the links. I don't normally tout for business but my guess is we could do this cheaply and quickly for you if you are interested!
john ATSIGNHERE PPTAlchemy.co.uk |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Buckeyegator | Outlook | 1 | 11-28-2011 08:53 PM |
Link multiple excel workbooks to publisher | bandcsaravia | Publisher | 0 | 10-24-2011 09:14 AM |
automatic link excel-powerpoint | tpltd | Office | 0 | 08-01-2011 07:30 PM |
Excel to Powerpoint Link issues | Weather | PowerPoint | 0 | 02-01-2011 02:02 PM |
Multiple IExplorer Tabs open with link | robertkjr3d | Outlook | 2 | 07-26-2010 11:30 AM |