Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Tables in 2007
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Tables in 2007
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Tables in 2007
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 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Tables in 2007
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 |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Tables in 2007
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 |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Tables in 2007
Hi Confused
See also this two articles http://msdn.microsoft.com/en-us/libr...ffice.11).aspx And http://msdn.microsoft.com/en-us/libr...ffice.11).aspx See also the links on the bottom of the pages -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Confused" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2007 Tables (Subtotal) | Excel Discussion (Misc queries) | |||
2007 Pivot tables | Excel Discussion (Misc queries) | |||
Pivot Tables in 2007 | Excel Discussion (Misc queries) | |||
2007 Pivot Tables | Excel Discussion (Misc queries) | |||
Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) |