A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Powerpoint, Publisher and Visio » Powerpoint
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Dynamic update of PPT slide displaying Excel worksheet range



 
 
Thread Tools Display Modes
  #1  
Old October 13th, 2005, 09:57 AM
Bernard
external usenet poster
 
Posts: n/a
Default Dynamic update of PPT slide displaying Excel worksheet range

Can the experts help wth this one please? I have an application which
displays a range from an Excel sheet as a single slide PPS. This is a
despatch display Screen for all to see. Data in the excel sheet is changing
on a regular basis and this needs to be reflected on the PPS display. I have
update links set to auto and also have tried Shyam Pillai's excellent update
add-in. It all works fine for about 15 minutes after starting and then stops.
By selecting edit/links, selecting the link and updating manually (still set
to auto), it resumes auto update for 5 minutes or so and then stops and so
on. Please folks, any ideas on fixing this so it updates continuously without
stopping? Many thanks for any advice which will be very much appreciated.
Bernie
  #2  
Old October 18th, 2005, 04:19 PM
Brian Reilly, MVP
external usenet poster
 
Posts: n/a
Default Dynamic update of PPT slide displaying Excel worksheet range

Bernard
Auto updating of links during a slide show function differently by
version. What version are you using?

And what mechanism are you using to force the update?

Brian Reilly, MVP


On Thu, 13 Oct 2005 01:57:02 -0700, "Bernard"
wrote:

Can the experts help wth this one please? I have an application which
displays a range from an Excel sheet as a single slide PPS. This is a
despatch display Screen for all to see. Data in the excel sheet is changing
on a regular basis and this needs to be reflected on the PPS display. I have
update links set to auto and also have tried Shyam Pillai's excellent update
add-in. It all works fine for about 15 minutes after starting and then stops.
By selecting edit/links, selecting the link and updating manually (still set
to auto), it resumes auto update for 5 minutes or so and then stops and so
on. Please folks, any ideas on fixing this so it updates continuously without
stopping? Many thanks for any advice which will be very much appreciated.
Bernie

  #3  
Old October 19th, 2005, 11:24 AM
Bernard
external usenet poster
 
Posts: n/a
Default Dynamic update of PPT slide displaying Excel worksheet range

Hi Brian
Many thanks for the reply. I am using XP with Office 2003. When the Excel
workbook is opened, I have code that opens the .ppt file in which the
particular worksheet is embedded and then runs the show on a second monitor
(the display). In this way the operator can make changes to the controlling
spreadsheet which are immediately reflected in another sheet in the workbook
which is the one copied into the .ppt file and therefore any changes update
the .ppt displayed on the second display monitor. For example, there is a
series of clocks that show time in different zones that update every ten
seconds. In the .ppt file, Edit/Links is set to auto update and Shyam
Pillai's "Update Links during Show" add-in has been loaded. The whole thing
works fine as I said but only for about 15 minutes in the first instance and
then for about 5 minutes after an update is actioned in Edit/Links.

I hope I have given the info you were seeking. I can send you the files if
you like.

Many thanks,
Bernard

"Brian Reilly, MVP" wrote:

Bernard
Auto updating of links during a slide show function differently by
version. What version are you using?

And what mechanism are you using to force the update?

Brian Reilly, MVP


On Thu, 13 Oct 2005 01:57:02 -0700, "Bernard"
wrote:

Can the experts help wth this one please? I have an application which
displays a range from an Excel sheet as a single slide PPS. This is a
despatch display Screen for all to see. Data in the excel sheet is changing
on a regular basis and this needs to be reflected on the PPS display. I have
update links set to auto and also have tried Shyam Pillai's excellent update
add-in. It all works fine for about 15 minutes after starting and then stops.
By selecting edit/links, selecting the link and updating manually (still set
to auto), it resumes auto update for 5 minutes or so and then stops and so
on. Please folks, any ideas on fixing this so it updates continuously without
stopping? Many thanks for any advice which will be very much appreciated.
Bernie


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2002 chart does not update when worksheet data changes proquant Charts and Charting 1 June 15th, 2005 12:23 AM
A way to convert Excel worksheet into Powerpoint slide juzion General Discussion 1 June 8th, 2005 01:38 AM
how to change range for dynamic chart in excel 2000 with button? ivan Charts and Charting 2 April 24th, 2005 04:10 AM
can you update a charts data range automatically in Excel? Cal@tech-etch Charts and Charting 2 October 29th, 2004 01:54 AM
Problems using Excel 97 worksheet in Excel 2002 plfoley Worksheet Functions 1 May 2nd, 2004 09:54 AM


All times are GMT +1. The time now is 11:10 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.