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

XMLWordPrintable

    • 1
    • Severity 3 - Minor
    • 2

      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

        1. Screen Shot 2021-06-25 at 6.57.16 PM.png
          127 kB
          Avik H
        2. Screen Shot 2021-06-25 at 6.56.37 PM.png
          174 kB
          Avik H
        3. GETPIVOTDATA-function.xlsx
          29 kB
          Avik H

            Assignee:
            Unassigned
            Reporter:
            Avik H
            Votes:
            2 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated: