Dynamically Expand the Source Data for Pivot Tables in Excel 2007

Without question, the new Tables Tools is my favorite feature  in Excel 2007 – this feature, alone, is worth the price to upgrade!

When you format a Data Range as a Table in Excel 2007, you can “append” new data to the table and the Table definition automatically expands to incorporate the new cells! If you create Pivot Tables based on a “Named Range” for your source data, this is GREAT NEWS!

Now, after appending the new data to your “Named Table: in Excel 2007, when you refresh your Pivot Table, you automatically get updated data in your Pivot Table report.

This can save you hours each month – at what – $50.00 per hour? $100.00 per hour? Watch these savings add up each month of the year

(Note: This is a re-post so that I can feed this video to my Podcast at the iTunes store.)

Follow this link, to view and download – for free – the episodes on my Podcast, “Danny Rocks Tips and Timesavers” at the iTunes store.

Learn how to “Quickly Create Excel Pivot Tables and Charts.”

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn


  1. Thank you for your comments. I do use a webmaster for setting up the structure of my website. However, for this site, he simply used – and slightly modified – on of the free WordPress Blog Themes.

    It is a nice, clean look and it is easy for me to add in and revise the content for the website.

    Danny Rocks


  1. […] more:  Danny Rocks Tips and Timesavers » Blog Archive » Dynamically … By pivot | category: pivot, pivot table | tags: definition-automatically, new-data, pivot […]

  2. […] Dynamically Expand the Source Data for Pivot Tables in Excel 2007 […]

Speak Your Mind