Broken link btw. PPT file and Excel file

[mlyons9999]

I have received a Powerpoint presentation, created on a
Windows PC, linked to an Excel worksheet.
The data from the Excel worksheet populates charts in the
Powerpoint presentation. I need to enter data into the Excel
worksheet and update the Powerpoint presentation
However when I open the Powerpoint presentation on a Mac
running Mac OSX v.10.2.8 it does not look for the Excel
worksheet in order to update the charts.
If I select a chart manually in the Powerpoint presentation, a
"linked worksheet object" item appears at the base of the "Edit"
menu. However when i click on the "linked worksheet object" item
I get the following error message: "The server application, source
file or item cannot be found. Check that the path and file name
are correct, or try reinstalling the server application"
Evidently the Powerpoint presentation cannot find the linked file.
How do I restore the link?

 

[Steve Rindsberg]

I have received a Powerpoint presentation, created on a
Windows PC, linked to an Excel worksheet.
The data from the Excel worksheet populates charts in the
Powerpoint presentation. I need to enter data into the Excel
worksheet and update the Powerpoint presentation
However when I open the Powerpoint presentation on a Mac
running Mac OSX v.10.2.8 it does not look for the Excel
worksheet in order to update the charts.

Do you have the XLS file in the same folder as the PPT file?

 

[mlyons9999]

Yes I do.

-----Original Message-----


Do you have the XLS file in the same folder as the PPT file?




.

 

[Steve Rindsberg]

OK.

Do you get a quick message about "updating links" when you open the file?
If not, it may be that the information isn't linked but embedded.



--
Posted to news://msnews.microsoft.com
Steve Rindsberg, PPT MVP
PowerPoint FAQ - www.pptfaq.com
PPTools - www.pptools.com
===============================

 

[mlyons9999]

Steve,
Thanks for taking an interest in this. I appreciate your efforts!
If the files are embedded, is there another tack I can take?
In Office vX I get no message about updating links.
Interestingly I have now tried to open the files under Virtual PC
v5, running Win 98 and Office 2000 versions of Excel and
Powerpoint, having placed the folder containing the "linked" files
on the top level of my C drive (I don't know much about Windows -
). With VPC I do get the "updating links" message when I open the
PPT presentation, but then it tells me it hasn't updated anything
because the linked file is unavailable. I'm wondering whether the
file names (even though they look the same to me) might
somehow have become changed between the PC and the MAC. I
unzipped them onto the Mac, perhaps I should try to unzip them
directly onto the windows disk image and see what happens.
The thing is, I don't really want to mess around with Windows. I
am assuming that such an Excel/Powerpoint tandem is pretty
normal and should work on the Mac . Most of all I would like to
understand, so I am wiser next time round
Mark

 

[Steve Rindsberg]

Thanks for taking an interest in this. I appreciate your efforts!

If the files are embedded, is there another tack I can take?

If so, you should be able to doubleclick to edit them, but this stuff seems
to work a bit differently going PC to Mac.

In Office vX I get no message about updating links.
Interestingly I have now tried to open the files under Virtual PC
v5, running Win 98 and Office 2000 versions of Excel and
Powerpoint, having placed the folder containing the "linked" files
on the top level of my C drive (I don't know much about Windows -
).

You'd want to put ALL the files, PPT and linked ones, in the same folder.
If you haven't done that, give it a shot.

With VPC I do get the "updating links" message when I open the
PPT presentation,

Ah. Then we know that they ARE linked and not embedded.

Let me see if I can make more sense of this here. It may take a bit 'cause
I'm getting swamped with honey-dos and a bad cold besides. Sigh. Cough.
Hack Yesss dear ...


but then it tells me it hasn't updated anything

 

[mlyons9999]

-----Original Message-----

If so, you should be able to doubleclick to edit them, but this stuff seems
to work a bit differently going PC to Mac.


You'd want to put ALL the files, PPT and linked ones, in the same folder.
If you haven't done that, give it a shot.

That was the case all along. The two files have always been in
the same folder.

Do you think the information about the links is just not crossing
the PC/Mac barrier. If so, could there be an option to save the file
differently at source in the PC?

Thanks
Mark