Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-18-2012, 04:42 PM
excel3 excel3 is offline Link and change source for multiple tabs from excel to powerpoint Windows 7 32bit Link and change source for multiple tabs from excel to powerpoint Office 2010 32bit
Novice
Link and change source for multiple tabs from excel to powerpoint
 
Join Date: Jan 2012
Posts: 1
excel3 is on a distinguished road
Default Link and change source for multiple tabs from excel to powerpoint

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
Reply With Quote
  #2  
Old 01-19-2012, 02:01 AM
JohnWilson JohnWilson is offline Link and change source for multiple tabs from excel to powerpoint Windows 7 64bit Link and change source for multiple tabs from excel to powerpoint Office 2010 32bit
Programmer
 
Join Date: Nov 2008
Location: UK
Posts: 1,912
JohnWilson has a spectacular aura aboutJohnWilson has a spectacular aura about
Default

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
__________________
Microsoft PowerPoint MVP 2007-2023
Free Advanced PowerPoint Tips and Tutorials
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Link and change source for multiple tabs from excel to powerpoint Multiple browser windows or tabs 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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:20 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft