New answers tagged


It's not possible to import range by adding a formula in the Pivot Table editor, you have to add there a reference to a range in the current spreadsheet. If you don't want that the sheet with the imported data be visible you could hide it. Another alternative is to use Google Data Studio. Depending on the purpose of your pivot table, you could use GDS to "...

Top 50 recent answers are included