Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel - PowerPoint links
Hi
I have three projectors running different looping PPpresentations. The input to these presentations are alle links to various Excel spreadsheets. I have installed an add-in called UpdateLinks, that automatically updates all the links everytime the presentaions has completed a single loop. This is quite smart because the presentations now automatically updates 24/7 in our production environment, whitout any manual tasks. Here I have a problem. When another user is editing one of the Excel spreadsheets and the PPpresentation automatically tries to open the same spreadsheet for the update sequence, the presentation computer stops the presentation and displays a massage asking if if I want to open the file af Read-Only. Here we manually have to click "Read-Only" before the presentation again continues. I have tried to share the workbooks, because then the message does not appear, but then I am not able to edit fx. graphs in excel. What do I do, fx to make the computer automatically select the Read-Only option? Other ideas eaer welcome, thanx. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel - PowerPoint links
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel - PowerPoint links
Hi Naveen
This sounds a bit complicated, but it is a sollution for my problem. Can You give me some input for the ''save'+'check if in use'+'back up''-macro/procedure? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel - PowerPoint links
BTW
To solve this in a more simple manner. Is it not much simpler just to write a macro that automatically selects the read only button if the spreadsheet is open allready. If possible what would a macro/procedure like that look like? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Data from Excel 2000 Worksheet with external links is not displayed when opened in Excel 2003 | Links and Linking in Excel | |||
How can I locate links in an excel file and fix if incorrect? | Excel Discussion (Misc queries) | |||
Excel template to mimic PowerPoint | Excel Discussion (Misc queries) | |||
How do I Break links Using Excel 2000 | Excel Discussion (Misc queries) |