Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 928737 - Last Review: May 14, 2007 - Revision: 1.3
A hyperlink does not work in an Excel 2007 client workbook that is published to Excel Services in SharePoint Server 2007
When you create a hyperlink in a Microsoft Office Excel 2007 client workbook that is published to Excel Services in Microsoft Office SharePoint Server 2007, the hyperlink does not work. This behavior occurs when you try to click the hyperlink by using the Excel Web Access Web Part.
This behavior occurs because Excel Services does not support relative hyperlinks. When the base address of the hyperlink is the base path of the SharePoint Server 2007 server in which the workbook is published, Excel 2007 converts the absolute path into a relative path. The relative path is based on the base path of the server.
To work around this behavior, configure Excel 2007 so that it does not update links when the workbook is saved. To do this, follow these steps:
- In Excel 2007, click the Microsoft Office Button
Collapse this imageExpand this image
- Under General, click Web Options.
- On the Files tab, click to clear the Update links on save check box.
This behavior is by design.
APPLIES TO
- Microsoft Office SharePoint Server 2007
- Microsoft Office Excel 2007
| kburl kbprb kbtshoot kbexpertiseinter KB928737 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate