#1
|
|||
|
|||
Help with excel and powerpoint hyperlink
Hi . Didnt know whether did i post it in the correct section . sorry if i have post it in the wrong section
i need some help to about this problem . I have an Excel Sheet that we use to track project progress. This sheet is open almost around the clock as people are constantly entering information into this sheet. I then have a PowerPoint presentation which links to this Excel file and grabs some details from it and then displays this PowerPoint on loop in our work area. I have it set up such that the links automatically update everytime the presentation loops back to the first slide. THE PROBLEM IS...because the excel sheet is open, when the PowerPoint attempts to grab information from the excel sheet it pops up a message telling me that the Excel sheet is open (by someone on my team entering progress results), and that I have to click "Read-Only" or "Notify" or "Cancel". If I click "Read-Only", the data does update properly. HOWEVER, I just want it to ALWAYS open the excel file in Read-Only when grabbing the data so that this spreadsheet can loop continuously without me having to ever touch the presentation. I'm thinking I may have to write some VB to make this happen. But even any guidance you could give me on that would be extremely helpful. Any advice? |
#2
|
|||
|
|||
I might be wrong but I think you can write one little script in PPT saying
Code:
application.DisplayAlerts = ppAlertsNone Let me know if that works. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel hyperlink in Powerpoint changing locations | frankfranssen | PowerPoint | 0 | 01-28-2014 03:15 AM |
PowerPoint 2010 - Changing an object that is a hyperlink | JimWS100 | PowerPoint | 1 | 07-01-2013 03:17 AM |
Hyperlink from PowerPoint to destination in remote PDF | joeldodenhoff | PowerPoint | 2 | 04-18-2013 02:01 PM |
Hyperlink warning for Powerpoint 2007 with Office 2003 | cinci-hal | PowerPoint | 0 | 03-01-2012 10:52 AM |
hyperlink in powerpoint to youtube video | Eilko | PowerPoint | 2 | 02-20-2012 09:34 AM |