How To Create A Pivot Table In Excel 2011

Tim Liu MSFT

Hi CLNguyenExcel,

I did a simple test:

Enter some data in book1-sheet1, select all the data>click the Data tab>Pivot Table>Manually create a pivot table>Existing sheets>click the button next to Location>select a rang in book1-sheet2>it creates the first pivot table. And then, I return to book1-sheet1 repeat steps mentioned above, select another range in book1-sheet2, it creates the second pivot table.

And then, I click one cell in the second pivot table>click Pivot Table tab>Move> click the button next to location>select a range in book1-sheet3>it moves the second pivot table to sheet3.

If these are same steps which you use, the two functions should work. If not, please record a video about how you operate these two functions. We want to check if we can reproduce the behavior from our side. You may just use mobile phone or QuickTime Player to record the video. Upload it to a public cloud storage (share with us a guest link. So, other community members can also discuss on this thread) or my private message. Moreover, please click Excel icon on the top bar>About Excel>let us know the detailed version of your Office 2011 for Mac.

Disclaimer: Microsoft provides no assurances and/or warranties, implied or otherwise, and is not responsible for the information you receive from the third-party linked sites or any support related to technology.

If anything is misunderstood, let me know.

Best regards,

Tim

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Hi Tim,

Thank you so much for your reply. I followed your steps exactly, and I managed to create two Pivot Tables on one sheet, and even move one Pivot Table to another sheet.

However, I can confirm that when I tried again on a workbook that already had pre-existing data, I was still unable to create a Pivot Table on an Existing Worksheet. I tried this with two workbooks with no luck. I can create a Pivot Table onto a new sheet, but if I try more than one then I am sent back to the original page of data.

Do you mean that the steps you listed out are the only way to get this to work? If so, I can confirm that it does work just fine, but I'm curious if there is no way to do the same with worksheets I have already been using for some time, or are pre-packaged with the online course I am taking.

Thank you so much.

Best,

CLNguyenExcel

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Tina Chen MSFT

Hi CLNguyenExcel,

Based on my test, I can create a Pivot Table on a existing worksheet with the steps below:

1. Create Pivot Tables in a workbook with the steps as Tim mentioned.

2. Then save the workbook.

3. Reopen the workbook, enter new data in book1-sheet1.

4. Create new Pivot Tables in book1-sheet2. (The previous data and Pivot Tables are existing in this workbook)

Please test on your side and let us know the result.

If the issue persists, please record a video to describe the symptom. Please send it to us via the way as Tim mentioned.

Also provide the detailed version of Excel. (Excel>About Excel)

This will help us to troubleshoot the issue.

Regards,

Tina

--------------------------------
* Beware of scammers posting fake support numbers here.
* Kindly Mark and Vote this reply if it helps, as it will be beneficial to more community members reading here.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Kimi Gao MSFT

Hi CLNguyenExcel,

Thanks for the PM .

From the video, you have tried the worksheets given by others. I want to confirm whether existed worksheets have problems as you can insert a pivot table in a new worksheet. If a new worksheet works fine, then it means the Pivot Table function works in Excel. And the steps to create a pivot table doesn't affect the function.

Let's create a new workbook and enter some data in it, then create a pivot table and chart on Sheet 2. Save the workbook to local. Reopen the workbook and try the same steps to create a pivot table in Sheet 2, does it work?

If it works, I want to collect the worksheet to test on our end. To protect your privacy, I have sent you the message via https://answers.microsoft.com/en-us/privatemessages/list .

If it doesn't work, I suggest you update to the latest version of Excel.

Regards,

Kimi

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Tim Liu MSFT

Hi CLNguyenExcel,

If the issue only related to those existing files, you may share with us a problematic file via replying to Kimi's private message when you have time.

Regards,

Tim

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.