GETPIVOTDATA

%3CLINGO-SUB%20id%3D%22lingo-sub-1650581%22%20slang%3D%22en-US%22%3EGETPIVOTDATA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1650581%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20do%20I%20reference%20a%20field%20on%20a%20different%20spreadsheet%20that%20I%20want%20to%20pull%20a%20value%20from%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1650581%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1650618%22%20slang%3D%22en-US%22%3ERe%3A%20GETPIVOTDATA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1650618%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F787828%22%20target%3D%22_blank%22%3E%40lfayj1963%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat's%20like%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3D'Another%20sheet%20name'!A1%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
New Contributor

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

3 Replies

@lfayj1963 

That's like

='Another sheet name'!A1

@Sergei Baklan 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.

 

@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