We have excel workbooks with sheets that contain hyperlinks to other sheets
within the workbook. We have these workbooks saved to a WSS 3.0 site. When
using Excel 2007 to edit one of these workbooks we use the local sharepoint
drafts folder. However this causes the hyperlinks to think they need to
reopen the document from the WSS site, rather than just navigate to another
sheet. When we disable use of the local sharepoint drafts location the links
work as expected. Is there another way to do this so the links work without
re-opening the document, but allow use of the sharepoint drafts location? Any
help is greatly appreciated.