This group (shown in figure 14) is all about the source data of a table and only applies if the data in the table has been imported into Excel using a database- or webquery or a sharepoint list.
If you click the arrow beneath the button, you’re offered a menu which amongst others also includes "Refresh All", with which you can refresh all external data ranges in your file.
This article has been published on the Microsoft site (in Dutch) With the release of Excel 2007, Microsoft has introduced a new concept of working with tables of data.
This new functionality is (not surprisingly) called "Tables".
Click this control to change the size of your table.
This group (see figure 12) has three controls: Figure 12: Tools group on Table Tools tab It is obvious what this control does.