Issue Summary

Excel Macro does not shows up correct results for GETPIVOTDATA-function

Steps to Reproduce

1. Create a new page
2. Attach GETPIVOTDATA-function.xlsx sheet mentioned in this ticket
3. In the same page now use Excel Macro to populate the data of this excel sheet. You can even upload separate excel sheets for the all the data form both the tabs of GETPIVOTDATA-function.xlsx sheet.
4. Publish the page now
5. Open GETPIVOTDATA-function.xlsx in excel now
6. Its been noticed that the results of GETPIVOTDATA-function is not same as it appears in the original excel sheet.

Expected Results

Results are not appearing correctly for the function in Excel Macro

Actual Results

Results should appear correctly for the function in Excel Macro

Workaround

Currently there is no known workaround for this behavior. A workaround will be added here when available