I have a table of 70,000 rows and 10 columns in Excel 2007. It is linked to
an Access 2007 table. The Insert Table menu option is grayed out. I must be
missing a basic understanding and cannot find any applicable documentation on
this. Also, assuming I can get this functionality, can I create multiple
tables (e.g., single filtered columns that can be used in the x/y variables
for a line graph. I have multiple graphs that I would like to update from
this main table using named tables. Currently, having to use Pivot Tables
and creating associated datasets for use in the graphs. These data sets do
not update on a refresh of the PTs and have to be created each update cycle
(have over 150 graphs to update).

Thanks in advance,

J Austin