Linking Excel to PowerPoint across a network

[Andy Webb]

I know this question has been asked before but the solutions don't seem to
work
with what I'm trying to do.

I can get PowerPoint to work with Excel fine, when all the files are on one
machine but
I need to update a Excel worksheet on one computer and have the updated
figure appear
in a PowerPoint running on another networked computer.

As I say, the Links seem fine when running on a single machine, it's across
a network I have the problem.

Thanks for any advice.

Andy

 

[Brian Reilly, MVP]

Andy, I haven't tried this yet, since I'm no longer a big fan of
linking (g). But try a quck test and let us know how it works.

Create the PowerPoint file on a network drive in the same folder as
the Excel data. Then open and test from several networked machines.
Should work.

Brian Reilly, MVP

 

[Andy Webb]

Tried this and I've tried sharing the worksheet across network,
that doesn't update either, (though I don't know if it should?).

What I'm puzzled by is this. The worksheet is inserted from an Excel file
into PowerPoint,
the cells within the inserted worksheet have the following link info in
them;

='Z:\My folder\[SORT.xls]SCORES'!C5

Does this look correct?

When both the Excel files and powerpoint are open on one machine the link
becomes local.

=[SORT.xls]SCORES!C5

Any other thoughts, I'm running out of ideas!

Thanks

Andy

 

[Kurt]

Hi Andy,
As far as I know, the linking is not working across the network, only
locally.
You will need a tool like DataPoint from www.PresentationPoint.com to
achieve this.

regards
Kurt.

 

[Austin Myers]

Andy,

Have you "mapped" the network drive on the client machine?


Austin Myers
MS PowerPoint MVP Team

PowerPoint Video and PowerPoint Sound Solutions www.pfcmedia.com

 

[Andy Webb]

I've downloaded the DataPoint trial software and I shall give that a go.

One question I forgot to ask is, does the folder with the Excel and
PowerPoint files in it
need to be on a machine running a server based operating system. I'm just
running
windows XP pro on all the machines, no XP Server.

I've tried mapping the HD, I've also tried UNC paths to the files.

I've tried it on different machines and also on a different network, all to
no avail.

So far the best I've got is to have the worksheets set to share, then having
them open on
both the machine with PowerPoint and the other networked computer. That way
saving the changes on the Excel only machine and having the shared worksheet
update
on the PowerPoint machine, causes PP to also update but this is messy.

Andy