Pivot table creation in excel

N

NRCan13

I have been working with pivot tables for some time now.
When I use to create them, excel would open up a new worksheet and dump the
pivot onto the blank worksheet.
Now, at my new job, same version of Excel, it prompts me with a message "Do
you want to replace contents of a sheet" meaning it will overwrite the data
you are using for your pivot table instead of creating a new worksheet for
the pivot.
 
S

ShaneDevenshire

Hi,

In step 3 of the Pivot Table Wizard you need to choose New Worksheet.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top