Dynamic excel cell ranges

  VNAM75 20:48 03 Sep 2008

If I have a pivot table based on the cell range A1:G100 and I want to add a few rows of data, how do I get the pivot table to calculate the extra rows without having to edit the cell range?

  Picklefactory 21:06 03 Sep 2008

Whilst there are some members here who can probably answer your query, and not intending to advertise or impinge on the expertise of this site, but you may get a wider and more rapid answer on a specialist Excel site for example click here

  VoG II 21:18 03 Sep 2008

I agree wholeheartedly with Picklefactory - especially as pivots have changed in XL 2007.

I am not an expert on pivots or I would respond here but I believe that what you want is certainly dooable.

  VNAM75 22:04 03 Sep 2008

Thanks both. I've just upgraded to 2007 and there is a lot of changes to get used to.

  Covergirl 22:46 03 Sep 2008

. . . . if . . . .

you insert your new rows above the last row in the spreadsheet. You can then right-click on the pivot table and Refresh Data

  VNAM75 23:16 03 Sep 2008

Never thought of that, but it defeats the purpose really.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Xiaomi Mi Mix 2 review

See mcbess's iconic style animated for Mercedes-Benz

iPhone X news: Release date, price, new features & specs

Black Friday 2017 : date, sites participants & bonnes affaires