Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 1
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   Report Post  
Junior Member
 
Posts: 6
Default

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://support.microsoft.com/search/... omm=1&res=20

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.




Quote:
Originally Posted by IainC View Post
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

--
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Client Safety Options - Intermittent error KaneSama2k3 Excel Worksheet Functions 0 March 17th 08 12:20 PM
Intermittent startup error -- inverted worksheet window in Excel 2 AceWriter01 Excel Discussion (Misc queries) 0 September 14th 07 04:42 PM
Error 1311. Source file not found Devdas Excel Worksheet Functions 0 May 16th 07 04:25 PM
Intermittent Error - Method 'Add' of object 'HPageBreaks' failed Jamey Weare Excel Worksheet Functions 1 December 22nd 06 02:40 AM
Error 1706. No valid source could be found for the product Microso Wiley C Excel Discussion (Misc queries) 0 August 8th 05 10:41 AM


All times are GMT +1. The time now is 12:53 PM.

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

About Us

"It's about Microsoft Excel"