Microsoft KB Archive/928975

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 17:34, 18 July 2020 by 3155ffGd (talk | contribs) (importing KB archive)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Article ID: 928975

Article Last Modified on 10/15/2007



APPLIES TO

  • Microsoft Office Excel 2007



SYMPTOMS

You create a workbook that contains a relative name in Microsoft Office Excel 2007. Then, you create a second workbook that contains a reference to the relative name. You save the second workbook in the Excel 97-2003 Workbook (*.xls) file format, and then close both workbooks. When you reopen the workbook that was saved in the Excel 97-2003 Workbook (*.xls) file format, the reference to the relative name is not updated as expected.

WORKAROUND

To work around this issue, use one of the following methods.

Method 1: Open the workbook that contains the relative name first

First, open the workbook that contains the relative name. Then, open the workbook that contains the reference to the relative name.

Method 2: Save both workbooks in the "Excel Workbook (*.xlsx)" file format

Save both the workbook that contains the relative name and the workbook that contains the reference to the relative name as Excel 2007 workbooks. For example, save both workbooks in the Excel Workbook (*.xlsx) file format.


Additional query words: excel2007 excel2k7 excel12 xl2007 xl2k7 xl12

Keywords: kbtshoot kbprb kbxlslink kbexpertisebeginner KB928975