Microsoft KB Archive/299303

= XL: GETPIVOTDATA Function Displays #REF! Error If External Reference Is Closed =

Article ID: 299303

Article Last Modified on 1/31/2007

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition
 * Microsoft Excel 2002 Standard Edition
 * Microsoft Excel 97 Standard Edition

-



This article was previously published under Q299303



SYMPTOMS
When you create a GETPIVOTDATA function that refers to a PivotTable in another file that is closed, the function displays a #REF! error when you attempt to update the link.



CAUSE
The GETPIVOTDATA function is designed to work with a PivotTable in the same workbook as the function, or in another workbook that is open.



WORKAROUND
To work around this issue, use either of the following methods:
 * Place the GETPIVOTDATA function in the same file as the PivotTable (in a blank area of the same sheet, or in another sheet), and then link the destination file to the appropriate cell.

-or-
 * Make sure that the file that contains the PivotTable is open whenever you work with the linked file.

Additional query words: XL2000 prb XL2002 XL97

Keywords: kbprb KB299303

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.