Forum Discussion

Copper Contributor

Jul 26, 2021

GETPIVOTDATA and XLOOKUP formula producing an #REF error within SharePoint workbook.

Hi all, I am having trouble diagnosing a formula issue regarding a GETPIVOTDATA formula capturing data from pivot table in another workbook within the same SharePoint file. The formula is as foll...

excel

SergeiBaklan

Diamond Contributor

Jul 27, 2021

KSuresh720

I see nothing wrong in formula. Repeated on my file:

=XLOOKUP([@[RS_Run]],
 'https://tenant.sharepoint.com/sites/mysite/Models/Test Models/test.xlsx'!Table1[A],
 'https://tenant.sharepoint.com/sites/mysite/Models/Test Models/test.xlsx'!Table1[B]
)

it works.