Sep 24 2021 03:00 AM
Hi,
I am using WIndows 10 and Excel from Office 365 for small business.
The function GETPIVOTDATA is returning #REF for some cells of a pivot table and returning the right value for others.
See please in attached file. The problem is clearly shown on sheet "Resumo Provisão Malha".
Cell F22 to F24 - function works properly
Cell F25 and F26 - function returns #REF
Thanks
Sep 24 2021 04:41 AM
I downloaded your file and it took almost 1 minute just to open it.
When verifying your data I could see that
Try to clean-up your data by removing unnecessary spaces or special characters. You can use the TRIM() funciont for that >>=TRIM(CLEAN(SUBSTITUTE(J2,CHAR(160)," ")))
Avoid use the whole excel range as data set for your pivot table.
Use the excel feature called Table, so everytime your range increases it is updated on your pivot table.
Sep 24 2021 07:23 AM
Sep 24 2021 07:25 AM
Sep 30 2021 02:01 AM