Pivot Tables in Excel 2007

B

bharat.pardasani

How do you change the data range for a pivot table in excel 2007
without deleting the table itself and redoing all the steps for pivot
table creation. e,g, yr current range is A1:D49 but u want the range
to be A1:D56 since u added some records for pivot table purposes.
 

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

Similar Threads

Pivot Tables in Excel 2007 vs 2003 1
Excel 2007 graphs/charts automatically populate with new data 1
Consolidate Pivot Tables/Cache using Excel 2003 1
Excel 2010 Slicer Connection / Pivot Table Problem 3
making an excel table visible for external data on pivot table 1
working with pivot tables from another worksheet 2
Excel 2007 Pivot table error "There are too many records to complete this operation" 3
Excel 2007 - Create Pivot table from another pivot table 6

Top