Is it possible to create a workbook that includes several PivotTables on their own sheet that calculate different data? I would like to create a workbook where I can plug in the data and have the information automatically populate. Thank you.
Reply from Richard Rost:
Sure. When creating the PivotTable you can choose to insert it in a new sheet or in a location in an existing sheet. You can in Excel 2013. I'm pretty sure you can in 2010 as well.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Excel 2010 Expert 7.
