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.)
Learn how to “Quickly Create Excel Pivot Tables and Charts.”
Save hundreds of dollars each month when you use a Pivot Table Play Now | Play in Popup | Download (230)
May 31st, 2010 at 6:36 PM
[...] more: Danny Rocks Tips and Timesavers » Blog Archive » Dynamically … By pivot | category: pivot, pivot table | tags: definition-automatically, new-data, pivot [...]
June 28th, 2010 at 2:56 PM
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.
Best,
Danny Rocks
December 14th, 2010 at 5:11 PM
[...] Dynamically Expand the Source Data for Pivot Tables in Excel 2007 [...]