Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-16-2010, 09:08 AM
chrisbru chrisbru is offline Auto-updating powerpoint from linked files for 3 weeks of data... Help? Windows XP Auto-updating powerpoint from linked files for 3 weeks of data... Help? Office 2003
Novice
Auto-updating powerpoint from linked files for 3 weeks of data... Help?
 
Join Date: Jun 2010
Posts: 1
chrisbru is on a distinguished road
Default Auto-updating powerpoint from linked files for 3 weeks of data... Help?

Hey everyone,



Every week we print out a HUGE amount of powerpoints for our three managers. Each team (there's 7 teams) has about 25 pages of data, mostly financial charts and explanations. Our managers keep 3 weeks of these charts in a binder. It's a large waste of time and paper, and I'd like to streamline it. Unfortunately, we do not save previous data since each powerpoint is made up of a number of linked files that changes as soon as we click "update links." No one on my team is willing to go each week as save last weeks as two weeks ago, this weeks as last weeks, and then update the current week.

So, my problem is that I need to create a new powerpoint. This powerpoint has to essentially contain three weeks of powerpoints, W(0) W(-1) and W(-2), for each team. This new powerpoint has to automatically slide W(-1) to W(-2), W(0) to W(-1), and automatically update the W(0) slides.

Does anyone have any ideas how to do this? I can't even begin to wrap my head around it.

Thanks in advance for your help!
Reply With Quote
  #2  
Old 07-08-2010, 04:29 AM
mugezhn mugezhn is offline Auto-updating powerpoint from linked files for 3 weeks of data... Help? Windows XP Auto-updating powerpoint from linked files for 3 weeks of data... Help? Office 2007
Novice
 
Join Date: Jul 2010
Posts: 16
mugezhn is on a distinguished road
Default

Hi,

I have a macro that copies excel pages and paste them to ppt in picture/bitmap format. The macro takes a few minutes to complete (of course this depends on the number of slides, your PC etc) Every week you may run this macro and save the previous week's data in picture format therefore that data would not be updated.

If this method works for you I may share the macro.

BR,
Reply With Quote
Reply

Tags
auto-update

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto-updating smaller documents in a larger word file nmawells Word 0 05-27-2010 07:20 AM
Auto-updating fields in Word 2007? V.V Ruby Soho Word 2 11-19-2009 04:35 PM
Auto-updating basic math functions & cross-referencing tables FranklinBluth Word Tables 13 11-19-2009 10:26 AM
Problem with Covnverting Linked Excel Data to Text trapdoor Word 0 05-25-2009 07:30 PM
PowerPoint Master - 50 LINKED slides - SLOW Update salfonsi PowerPoint 0 09-27-2008 02:55 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:44 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