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

--

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.