Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Unable To Create Pivot Table In Existing Worksheet

  1. #1
    New Member
    Join Date
    Dec 2009
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Unable To Create Pivot Table In Existing Worksheet

    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

  2. #2
    New Member
    Join Date
    Jul 2012
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Unable To Create Pivot Table In Existing Worksheet

    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

  3. #3
    New Member
    Join Date
    Aug 2012
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Unable To Create Pivot Table In Existing Worksheet

    Quote Originally Posted by esoktoev View Post
    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,

  4. #4
    New Member
    Join Date
    Aug 2012
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Unable To Create Pivot Table In Existing Worksheet

    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.

  5. #5
    New Member
    Join Date
    Jan 2015
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Unable To Create Pivot Table In Existing Worksheet

    Quote Originally Posted by esoktoev View Post
    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/art...f-24018b7f0f64

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •