Get Pivot Data

Question

Hi all.

I am building a worksheet that will pull data from a separate workbook in a pivot table. When I was using excel on my computer, i build the formula using GETPIVOTDATA and it all went well. Everything came through. When I saved it to the OneDrive/Sharepoint and opened the document online, giving the thumbs up to the connections (the corresponding workbook is also saved in the OneDrive/Sharepoint folder), the cells are blank. The other cells that also pull data from the corresponding workbook are working well, it is just the GetPivotData cells that are blank. The equation looks good so I am not sure where the error is. Thoughts?

Answer 1

I thought of that too so I opened the source workbook prior to opening the one with the equations...

Answer 2

Hi,

As far as I know, that function only works when the source workbook is open. If it is not open, you will get an error.

Answer 3

Thanks for the reply! Yes, that is how it was originally created- I opened the filed from the sync folder, built it out, all was good on the sheets (the correct information showing), then I did the sync with the drive. When I then opened the synced files on the drive, the formula is there but not the correct result.

Answer 4

Dear Tif,

Generally, if you sync the two workbooks with the OneDrive sync client, open them with the Excel client from the OneDrive local sync folder, create the pivot table and type the GETPIVOTDATA formula, the value got from GETPIVOTDATA should be synced to Excel for the web as well.

If you haven't done that, I suggest you try it to see and let us know the result.

Best Regards,

Cliff