Unable To Create Pivot Table In Existing Worksheet

H

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

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying
Sort by date Sort by votes
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
 
Upvote 0
esoktoev said:
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
Click to expand...

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,
 
Upvote 0
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.
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Solved
Pivot Table Slicers mystery!!!
Replies
9
Views
784
adambc
A
C
  • Question
Confused over pivot table calculations :-(
Replies
1
Views
240
number kruncher
N
J
  • Question
Filter Pivot Table Generated From PowerQuery Data Model
Replies
1
Views
74
jdorby
J
M
  • Question
Excel pivot table query - retaining filters on pivot in absence of data
2
Replies
10
Views
976
Alex Blakenburg
A
R
  • Question
Pivot table
Replies
3
Views
106
GraH
GraH

Forum statistics

Threads
1,214,646
Messages
6,120,718
Members
448,986
Latest member
andreguerra

Share this page

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
Back
Top