Forum Discussion

lfayj1963's avatar
lfayj1963
Copper Contributor
Sep 09, 2020

GETPIVOTDATA

How do I reference a field on a different spreadsheet that I want to pull a value from?

Excel
    • lfayj1963's avatar
      lfayj1963
      Copper Contributor
      Sep 09, 2020

      SergeiBaklan I entered this  =GETPIVOTDATA('[CCC Plus Dashboard Call Center 08.01.20 to 08.31.20.xlsx]Call Center 08.01 to 08.31 DATA'!$G$6) and I'm getting the error You've entered too few arguments for this function.

       

      • SergeiBaklan's avatar
        SergeiBaklan
        MVP
        Sep 09, 2020

        lfayj1963 

         

        =GETPIVOTDATA("B",Sheet1!$F$4,"A","a1")

        =GETPIVOTDATA("B",[PTfile.xlsx]Sheet1!$F$4,"A","a1")

        =GETPIVOTDATA("B",'C:\Test\[PTfile.xlsx]Sheet1'!$F$4,"A","a1")

        all works

Share

Resources