Intermittent Error: Source not found

[IainC]

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]

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.

--
ddibble