Hi, I have the following situation: I created a spreadsheet in microsoft excel 2003 for windows and used the GETPIVOTDATA function. I later tried opening the same file on my MAC ( Excel 2004 for MAC ) and the getpivotdata function didn't work. Keep in touch and stay productive with Teams and Office 365, even when you're working remotely. GETPIVOTDATA function. Excel for Office 365.
![]() ![]() ![]()
The GETPIVOTDATA formula has several problems.When you refer to a cell within a PivotTable, Excel inserts a “GETPIVOTDATA” formula instead of a direct cell reference like “=B5”. If you copy and paste it to another cell, let’s say the cell below, you still refer to the same cell. That would be different with direct cell links: =B5 would automatically change to =B6 when copying to the cell below.Another problem occurs when you change the fields of your PivotTable or rename them.
You will easily receive #REF errors in such case.That’s why direct cell links are in most cases a better solution.
![]() Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2023
Categories |