Hi

If you convert a range of data to a Table, then it automatically becomes
dynamic.
You do not need to add any formulae to it at all.

Debra's reference to creating Dynamic Ranges is for versions of Excel that
do not have Table as an option, i.e. prior to XL2007.
If you click on her link on that page
http://www.contextures.com/xlExcelTable01.html
that takes you to a page discussing Tables.

Having done Insert tabTable, whilst on the Insert tab there is then an
Option to report with a Pivot Table.
This will use the Table you have created as the source.
Any new data you add to your table will then automatically be inserted in
your Pivot Table, when you right click on the PT and choose Refresh
--
Regards
Roger Govier

"Confused" wrote in message
...
Thanks for answering. I found a more indepth discussion at
www.contextures.com. I am still wondering why you have to go thru the
process of creating a dynamic data source if you use the table name as the
data source. Do you know why? Is the name equivalent to an absolute
reference?

http://www.contextures.com/xlPivot01.html
--
Thanks.
Confused


"Eduardo" wrote:

Hi,
Go to the excel help and type Tables then open the one that says Demo:
Organize your data by using an Excel table, and then in How to do it,
click
on Overview of Excel Tables

if this helps please click yes, thanks

"Confused" wrote:

What are the advantages to converting a list to a table in 2007? Why
does
the table have a name?

I did read in help that you can post a 2007 table to sharpoint
services.
What does that mean?
--
Thanks.
Confused