The information in this article applies to:
SYMPTOMSIn Microsoft Excel 98 Macintosh Edition, when you create a new PivotTable or refresh data for an existing PivotTable (by clicking Refresh Data on the Data menu), you may receive the following error message:
CAUSEThis problem occurs when the first row of the range from which the PivotTable is attempting to pull data contains one or more empty cells. RESOLUTIONTo resolve this problem, use either of the following methods. Method 1Modify the first row so that it does not contain any empty cells.Method 2Change the range the PivotTable references to a range where the first row does not contain empty cells. To change or to determine the range an existing PivotTable references, do the following:
REFERENCES
For more information about PivotTables, click the Office Assistant, type
pivottable, click Search, and then click to view "Create a PivotTable."
Q179216 OFF98: How to Use the Microsoft Office Installer Program Additional query words: XL98
Keywords : kbdta xlpivot |
Last Reviewed: February 1, 2000 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |