Pivot table variable location

%3CLINGO-SUB%20id%3D%22lingo-sub-3193374%22%20slang%3D%22en-US%22%3EPivot%20table%20variable%20location%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3193374%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EThe%20formula%20for%20the%20location%20of%20my%20pivot%20table%20is%20%22Sheet1!F28%22%20all%20the%20data%20and%20table%20are%20on%20sheet%201.%20I%20would%20like%20to%20change%20the%20F28%20to%20the%20contents%20of%20cell%20G4.%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EIn%20other%20words%20the%20cell%20G4%20at%20the%20moment%26nbsp%3B%20reads%20F18%20but%20this%20changes%20as%20my%20data%20spreads%20to%20more%20rows.%20I%20would%20like%20the%20location%20of%20the%20pivot%20table%20to%20change%20as%20more%20data%20is%20added.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3Eis%20this%20possible%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3193374%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3193843%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20table%20variable%20location%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3193843%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F350245%22%20target%3D%22_blank%22%3E%40Hairsuit%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat's%20better%20to%20use%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fgetpivotdata-function-8c083b99-a922-4ca0-af5e-3af55960761f%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EGETPIVOTDATA%20function%20(microsoft.com)%3C%2FA%3E%26nbsp%3Bor%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fcubevalue-function-8733da24-26d1-4e34-9b3a-84a8f00dcbe0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ECUBEVALUE%20function%20(microsoft.com)%3C%2FA%3E%26nbsp%3Bdepends%20on%20do%20you%20work%20with%20data%20model%20or%20not.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

The formula for the location of my pivot table is "Sheet1!F28" all the data and table are on sheet 1. I would like to change the F28 to the contents of cell G4.

In other words the cell G4 at the moment  reads F18 but this changes as my data spreads to more rows. I would like the location of the pivot table to change as more data is added. 

is this possible?

2 Replies

@Hairsuit 

That's better to use GETPIVOTDATA function (microsoft.com) or CUBEVALUE function (microsoft.com) depends on do you work with data model or not.

@Sergei Baklan 

Thank you for your reply but it does not solve my queery.