A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Powerpoint, Publisher and Visio » Powerpoint
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

[2007] Links to Excel breaking



 
 
Thread Tools Display Modes
  #1  
Old May 19th, 2010, 02:01 PM posted to microsoft.public.powerpoint
Karol Kozimor
external usenet poster
 
Posts: 1
Default [2007] Links to Excel breaking

Hi,

I have an excel file and a presentation, both placed in different
directories on a network share mapped to a network drive. I then copy
a graph or a spreadsheet range from the .xls file to the presentation,
using Paste Special - Paste Link. I check the link in the Edit Links
dialog and it shows the absolute path to the object ("\\network\share
\directory\file.xlsm!sheet[file.xlsm]sheet chart_id"; don't ask me why
it's like that). All's good, so I hit save and close the presentation.

I then reopen the same presentation immediately and check Edit Links
again. in 2/3 (?) of the cases the path element of the link I just
pasted will now be truncated, and the link will show as relative
instead. Attempts to update it (manually or automatically) will fail
as the linked file is in a different directory. If I hit Change Source
and navigate to the right file, the path will fix itself (though
usually still remain relative, ie. "..\file.xlsm") and the link will
subsequently work all the time.

Has anyone seen this bug? Is there a way to avoid it? The files need
to stay in different directories for reasons that are beyond my
control I'm afraid.

Best regards,

Karol Kozimor
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:38 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.