Unable To Create Pivot Table In Existing Worksheet

huntermaclean

New Member
Joined
Dec 10, 2009
Messages
3
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
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

esoktoev

New Member
Joined
Jul 20, 2012
Messages
2
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

New Member
Joined
Aug 31, 2012
Messages
1
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

New Member
Joined
Aug 31, 2012
Messages
6
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.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,891
Messages
5,834,263
Members
430,273
Latest member
Windrunner

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top