Podcast
Questions and Answers
Where is the best place to put a new PivotTable to avoid cluttering the display?
Where is the best place to put a new PivotTable to avoid cluttering the display?
- On an existing worksheet
- On a separate workbook
- On its own worksheet (correct)
- On a summary worksheet with multiple visualizations
Can a new PivotTable be placed on an existing worksheet?
Can a new PivotTable be placed on an existing worksheet?
- No, it is not possible
- Yes, but it is not recommended
- Yes, but only if it is the only visualization on the worksheet
- Yes, it is possible (correct)
In what situation can a new PivotTable be placed on an existing worksheet?
In what situation can a new PivotTable be placed on an existing worksheet?
- When the worksheet is hidden
- When the worksheet is empty
- When it is part of a summary worksheet with multiple visualizations (correct)
- When it is the only visualization on the worksheet