How to edit the Pivot Table data range?

**smartcard** · 12-26-2006, 04:02 AM

I have a Pivot table that is taking the data from another sheet of the same Excel file.

I need to know how can I edit the data range? When I was creating the Pivot table I was assigning the data rage as data!$A$3:$E$21 now I need to edit it to data!$A$3:$E$50

Thank you,

**VBA Noob** · 12-26-2006, 04:57 AM

Hi,

You can right click anywhere in the pivot and click wizard table and then click back which takes you to the range or select Tools > Customise > then select the toolbar tab and select Pivottable and again select wizard.

Another way is to make the range dyamic. See link for instructions

http://www.contextures.com/xlPivot01.html

VBA Noob

How to edit the Pivot Table data range?

LinkBack

Thread Tools

Rate This Thread

Display

How to edit the Pivot Table data range?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions