Tables in 2007

[Confused]

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?

 

[Eduardo]

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]

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

 

[Eduardo]

Hi,
the name is equivalent to an absolute reference this is why you add the
offset formula to make it dinamic

 

[Roger Govier]

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 tab>Table, 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

 

[Ron de Bruin]

Hi Confused

See also this two articles
http://msdn.microsoft.com/en-us/library/dd637097(office.11).aspx

And
http://msdn.microsoft.com/en-us/library/dd637097(office.11).aspx

See also the links on the bottom of the pages