Unable To Create Pivot Table In Existing Worksheet

[huntermaclean]

Also, I cannot move the Pivot Table from the new Worksheet it is created in, to my existing Worksheet.

I am running Excel 2011 for Mac.

I have a Worksheet with a small amount of data, and when I click the Pivot Table button it automatically creates the Pivot Table in a new Worksheet. The Pivot Table data is fine, but I want it to display alongside the source data.
I've tried using the Move Pivot Table option and choosing to Create Pivot Table in Existing Worksheet and choosing a source cell alongside my current data, but nothing appears. Also, I checked in Edit menu and found that the Pivot Table appears to have not even been created/moved because there is no option to undo it.

Appreciate any help, let me know if you have any further questions.

Hunter

 

[esoktoev]

Hi, I have exactly the same problem... Saw no reply to this post and was wondering if you figured out how to do it? How to create a pivot alongside the original data?

Please, let me know.

Would greatly appreciate the help.

Thank you,

Ezhena

 

[Lilian]

Hi, I have exactly the same problem... Saw no reply to this post and was wondering if you figured out how to do it? How to create a pivot alongside the original data?

Please, let me know.

Would greatly appreciate the help.

Thank you,

Ezhena

Hi, I am facing exactly the same problem on my Excel 2011 for Mac. Wonder whether you have managed to figure out the issue. Your reply is appreciated. Thanks,

 

[hlb129]

Click a cell on the sheet. Go to Insert> pivot table. select the range of data you wouldlike to use> select ok.

also you must have labeled columns. Hope it helps you.

 

[Anclop]

Hi, I have exactly the same problem... Saw no reply to this post and was wondering if you figured out how to do it? How to create a pivot alongside the original data?

Please, let me know.

Would greatly appreciate the help.

Thank you,

Ezhena

Office online has actually answered this question:

https://support.office.com/en-ca/ar...e-report-0c220f35-e478-49aa-beaf-24018b7f0f64