Pivot table in Google sheets without importing data between sheets [closed]

Question

Closed. This question needs to be more focused. It is not currently accepting answers.

---

Want to improve this question? Update the question so it focuses on one problem only by editing this post.

Closed 6 months ago.

Improve this question

I have two sheets sheet1 and sheet2. Without pulling all the data from sheet2 into sheet1, how can I create pivot table in sheet1?

Answer 1

EDIT
(following OP's comment)

I am afraid you cannot.
Pivot only accepts references to ranges from within the same spreadsheet.

As a workaround though, you could create the pivot table in one spreadsheet and then use IMPORTRANGE to refer to it in another spreadsheet.

In our example it would be

=IMPORTRANGE("xxxxxxx", "Sheet3!Q7:R13") 

---

Original answer

You need to choose the range from one sheet and create it in a cell in the other as shown in the following image