getpiovotdata

  1. N

    Excel not subtracting properly causing "un-rounding"

    Through my entire process, I round everything with the Round formula since these numbers are designated to be $s to go into an ERP system that should have everything rounded to the 2nd decimal place. The final step in my process is subtracting my post-process rounded side to what it should...
  2. Rainbow_P

    Please help: Reference error in GETPIVOTDATA (pivot table in another sheet)

    Good day! Can you please help me with a reference question? A workbook has 2 sheets. Sheet1 is a pivot table. In sheet2, I use GETPIVOTDATA to return some values from the pivot table in Sheet1. In sheet2, cells C2 and D2, there are direct formulas when I just clicked the cells (I want to...
  3. S

    #REF! error when referencing a cell using GETPIVOTDATA

    I am trying to use getpivotdata with a cell reference but get an error when adding the cell reference.
    • Stevepttn
    • Thread
    • cell referecing getpiovotdata help pivot ref error tabel
    • Replies: 0
    • Forum: Excel Questions
  4. F

    Change GETPIVOTDATA item selection to text instead of cell?

    I have a GetPivotData formula in cell G5 that refers to "Blue" (in cell A5) as item1, and the output of the formula is 100. When I copy the formula to cell G6, of course since GetPivotData locks all the values, my output is still 100 and no cell references have changed. The only piece of the...
  5. ladyday

    GetPivotdata Assistance Needed

    I need assistance with linking a cell to a total in a Pivot table. I have produced a summary table that displays a groups of totals and I would like to the link the cells to the totals in each pivot table so if the table expands or is collapsed the information is display correctly.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top