Microsoft Office Tutorials and References
In Depth Information
Working with Excel Tables
Here’s the impressive bit. When data is added to the table, Excel automatically expands the range of the
table and incorporates the new range into any linked object. That’s just a fancy way of saying that any
chart or pivot table tied to an Excel table automatically captures new data without manual intervention.
For example, if I add July and August data to the end of the Excel table, the chart automatically
updates to capture the new data. In Figure 11-21, I added July with no data and August with data to
show you that the chart captures any new records and automatically plots the data given.
Figure 11-21: An Excel table automatically expands when new data is added.
Take a moment to think about what Excel tables mean to a data model. Pivot tables never have to be
reconfigured, charts automatically capture new data, and ranges automatically keep up with changes.
Converting an Excel table back to a range
If you want to convert an Excel table back to a normal range, you can follow these steps:
1. Place your cursor in any cell inside the Excel table and select the Table Tools Design tab in
2. Choose the Convert to Range command, as shown in Figure 11-22.
3. When asked if you’re sure (via a message box), click Yes.
Figure 11-22: To remove Excel table functionality, convert the table back to a range.
Any object you have connected to the range (pivot tables, charts, and so on) will continue to work.
However, they will no longer dynamically update as you add or remove data from the range.