Microsoft KB Archive/928737: Difference between revisions

From BetaArchive Wiki
(importing KB archive)
 
m (Text replacement - "[[File:../gfx/" to "[[File:")
 
Line 55: Line 55:


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:
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'''[[File:../gfx/office2007filebutton.jpg|[GRAPHIC: Microsoft Office Button]]], click '''Excel Options''', and then click '''Advanced'''.
# In Excel 2007, click the '''Microsoft Office Button'''[[File:office2007filebutton.jpg|[GRAPHIC: Microsoft Office Button]]], click '''Excel Options''', and then click '''Advanced'''.
# Under '''General''', click '''Web Options'''.
# Under '''General''', click '''Web Options'''.
# On the '''Files''' tab, click to clear the '''Update links on save''' check box.
# On the '''Files''' tab, click to clear the '''Update links on save''' check box.

Latest revision as of 07:44, 20 July 2020

Knowledge Base


A hyperlink does not work in an Excel 2007 client workbook that is published to Excel Services in SharePoint Server 2007

Article ID: 928737

Article Last Modified on 5/14/2007



APPLIES TO

  • Microsoft Office SharePoint Server 2007
  • Microsoft Office Excel 2007



SYMPTOMS

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.

CAUSE

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.

WORKAROUND

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:

  1. In Excel 2007, click the Microsoft Office Button[GRAPHIC: Microsoft Office Button], click Excel Options, and then click Advanced.
  2. Under General, click Web Options.
  3. On the Files tab, click to clear the Update links on save check box.


STATUS

This behavior is by design.


Additional query words: ECS EWR WSSv3 MOSS XL2007 Excel2007 MOSS2007 XLServices ExcelServices

Keywords: kburl kbprb kbtshoot kbexpertiseinter KB928737