Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Jan 2007
    Location
    Gray, Louisiana, USA
    Posts
    289
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pivot Table Range (2003 and 2007)

    I created a Pivot Table, It works fine, The range is C5 to K48

    My question is can you increase the range from within the Pivot Table?
    I add Data regularly to the sheet the Pivot Table looks at, and everytime I've ended up having to delete and re-creating the Pivot Table to include the added data rows.
    I can't locate where to update the range.....Thanks

  2. #2
    2 Star Lounger
    Join Date
    Jan 2007
    Location
    Gray, Louisiana, USA
    Posts
    289
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pivot Table Range (2003 and 2007)

    I found it in help. Its a bit different on the two versions.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •