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 Excel » Links and Linking
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Intermittent Error: Source not found



 
 
Thread Tools Display Modes
  #1  
Old November 17th, 2009, 12:51 PM posted to microsoft.public.excel.links
IainC
external usenet poster
 
Posts: 2
Default Intermittent Error: Source not found

A colleague has had the following problem since our office upgraded to
Excel 2007:

There is one main spreadsheet that contains a user-friendly menu. This
menu spreadsheet contains hyperlinks to other spreadsheets that are
usually stored in a network drive. The spreadsheets accessed from the
menu contain links (not hyperlinks - just link formulas) to other
spreadsheets on the network.

After the upgrade, when the user accesses a spreadsheet through a
hyperlink on the main menu, the links in that spreadsheet will work
correctly, but, after a number of days, they will inevitably fail with
the error Source not Found. If, however, the user forgoes the menu
spreadsheet and instead navigates to the network folder directly and
opens a file directly by double-clicking on it, the links in that file
will show as "OK" and will hold.

Any pointers to a solution would be greatly appreciated.

Many thanks,

Iain

--

  #2  
Old November 19th, 2009, 03:55 AM posted to microsoft.public.excel.links
ddibble
external usenet poster
 
Posts: 1
Default Intermittent Error: Source not found


Iain,

It may be a mapping issue. If your hyperlinks are to different drives
and all of the hyperlinks to those drives fail it may be due to a
change in the network mapping. The hyperlinks may be 'relative' and
not translating the changes. To test this, open up windows explorer
and go to the directory of one of the files you have a non-working
hyperlink for. Then go back to your spreadsheet and hold the mouse
over the hyperlink. If the path in the hyperlink does not match the
path through windows explorer then you will have to update the
hyperlink with the current path. Maybe that will do it.

If you are getting to the Excel file through MOSS (Microsoft Office
Sharepoint Server) then check out this knowledge base article:

http://support.microsoft.com/kb/928737

It is a similar network path issue that is known to be a problem.

For that matter you may want to look at some of the other 'hyperlink'
issues that Microsoft has addressed:

http://tinyurl.com/ycqd86a

If you don't have a lot of links on your user friendly menu then you
may be better off just manually 're-sourcing' your links. Not the most
efficient route, but then Excel 2007 should definitely recognize it.




IainC;901419 Wrote:
A colleague has had the following problem since our office upgraded to
Excel 2007:

There is one main spreadsheet that contains a user-friendly menu. This
menu spreadsheet contains hyperlinks to other spreadsheets that are
usually stored in a network drive. The spreadsheets accessed from the
menu contain links (not hyperlinks - just link formulas) to other
spreadsheets on the network.

After the upgrade, when the user accesses a spreadsheet through a
hyperlink on the main menu, the links in that spreadsheet will work
correctly, but, after a number of days, they will inevitably fail with
the error Source not Found. If, however, the user forgoes the menu
spreadsheet and instead navigates to the network folder directly and
opens a file directly by double-clicking on it, the links in that file
will show as "OK" and will hold.

Any pointers to a solution would be greatly appreciated.

Many thanks,

Iain

--





--
ddibble
 




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 03:16 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.