Link Excel Share Workbook with PowerPoint

  • Thread starter Thread starter Kyri
  • Start date Start date
K

Kyri

Hi. I created an Excel Share Workbook for my team and linked it to a
PowerPoint file so that managers can only see part of the data we enter. We
update the data regularly and I’m having trouble finding a way to a) change
the PowerPoint to a share file so that it would be accessible to everyone b)
get it to automatically update itself. Can you help?

Many Thanks
 
Hi,

To know why you cant change visibility on the sharer, you'd have to explain
how the share is set up. As for automatically updating the information, try
these:

PowerPoint 2007 won't update links to files on network drives
http://www.pptfaq.com/FAQ00930.htm


Graphs don't update automatically
http://www.pptfaq.com/FAQ00025.htm

An Access sample:

Update embedded charts and worksheets in a running presentation from Access
data (Naresh Nichani and Brian Reilly)
http://www.pptfaq.com/FAQ00922.htm


--

Regards,
Glen Millar
Microsoft PPT MVP

Please tell us your PowerPoint version

Tutorials and PowerPoint animations at
the original www.pptworkbench.com
glen at pptworkbench dot com
 
Many Thanks Glen

Here is some further info as requested:

The spreadsheet includes graphs and tables;
I converted the spreadsheet to a Shared Workbook (from Tools) whereby the
data is updated every 5 minutes (is there another way? Can changes
automatically reflected straight away?);
The links between Excel and PowerPoint are done by the use of Paste Special;
Both documents are on a common server (all users can access both documents).

The problem I have is with the PowerPoint because at the moment is only one
person can have it open, the rest can only open it as Read Only.

I hope this would give you all the details you need, if not just let me know.

Regards
 
Back
Top