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

"Confused" wrote:

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