I'm trying to create somewhat of a dashboard which has object links to various excel spreadsheets (these excel spreadsheets get updated either by automatic extraction from a database or users edit them as they see fit for annoucements etc. Now i'm making a macro to update the links to the excel spreadsheet (among other things) but if the system is using the excel file or a user has it open gives the usual options about read only, notify etc. My problem is that all i ever want powerpoint to do is read these excel sheets (I don't see why it wants to open it with write access anyway just to update the links). Is there anyway i can specify for it to update the links as read only?
Powerpoint 2007 and Object Links
- Thread starter Gammawolf
- Start date
Permabanned
- Joined
- 28 Dec 2009
- Posts
- 13,052
- Location
- london
There might be a command line switch to open excel spreadsheets as read only even if they are not open. so force read only. But i doubt powerpoint would support command line switches. You might be able to do it by not using the excel object within powerpoint. by choosing a basic command or dos object, if it exists, then run a batch file or something that runs the excel open command with correct switches. But sounds like a waste of time to me, might be a better way to do what you want. did you try doing a dashboard within excel and not powerpoint. Maybe do a website as a dashboard.
I would be fine with a dashboard from within excel, my inital reasoning for powerpoint was for the fullscreen, since this is going to be looping in a public place it needs to look slick, I wasn't sure if you could hide all the excel componets like top window bar and sheet pages etc.