![]() |
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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
![]()
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
|
|||
|
|||
![]() 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 | |
|
|