Powerpoint loses excel links when presentation is sent out via ema

[Silhouette17]

I have a powerpoint presentation with links to an excel file which works
perfectly from the folder in which it is stored.

However, I need to send the presentation and the excel spreadsheet that the
information is linked from via email to external people.

Even if they save both the presentation and the excel file in the same
folder, the links don't work and I cannot expect them to reset up all the
links.

Any ideas how I can get around this?

Thanks

Silhouette

 

[Silhouette17]

Embedding the Excel info solves the linking problem but then the Excel data
isn't linked. Changes to the Excel file no longer update the PPT, so that may
or may not be an answer for you.

If you include a little VBA code in the presentation, do you think they'd be
able to run it to fix up the links?




==============================
PPT Frequently Asked Questions
http://www.pptfaq.com/

PPTools add-ins for PowerPoint
http://www.pptools.com/


.
Hi Steve

Thanks for getting back to me.

I am updating the excel file from a database and producing a report in ppt
with the data that has been populated; so each time I update the report,
ideally I would like the link to work in ppt.

However, I would be happy to save the ppt slides with the information and
lose the links except that I am using 'paste special' to copy the
information. Ideally I would prefer not to embed excel as I assume the
recipients would have to 'open' the embedded file each time which on a 30
page report........could be a bit tiresome!!!

How complex would the VBA stuff be as it is likely that most people would be
happy to run something....

Hope this makes sense.

Cheers,

S

 

[Silhouette17]

Hi Steve

You are brilliant - thank you, that works perfectly.

However one final question, is there any way for one icon I can retain a
link to a url?

Thanks

S

[a one and a two and a-snippasnippasnipparoo]

Thanks for getting back to me.

I am updating the excel file from a database and producing a report in ppt
with the data that has been populated; so each time I update the report,
ideally I would like the link to work in ppt.

However, I would be happy to save the ppt slides with the information and
lose the links except that I am using 'paste special' to copy the
information. Ideally I would prefer not to embed excel as I assume the
recipients would have to 'open' the embedded file each time which on a 30
page report........could be a bit tiresome!!!

How complex would the VBA stuff be as it is likely that most people would be
happy to run something....

Hope this makes sense.

Perfect sense. And it makes things simpler yet.

You could continue to do exactly what you're already doing but add one step before
distributing the PPTs ... run a little code that'll ungroup all of the linked Excel
OLE objects. This tosses away the link and leaves you with just a picture of the
graph or worksheet object, the one you see when you're not editing the object
normally. And you can run the code from another presentation, so the distributed
PPT doesn't need to contain any code itself.

The code here's a start:

Ungroup all the OLE objects in a presentation
http://www.pptfaq.com/FAQ00326.htm




==============================
PPT Frequently Asked Questions
http://www.pptfaq.com/

PPTools add-ins for PowerPoint
http://www.pptools.com/


.