Hi,

I for one need more info - for example, are you in one table when you are
trying to create the second table?

Can you create multiple tables? - sure. But if a range is a table then you
can't create a table from the table. But since it sounds like the table is
created from a connection to an Access Database, you can create a second
table by connecting to Access a second time, no problem.

I'm not sure what you mean by: "can I create multiple
tables (e.g., single filtered columns that can be used in the x/y variables
for a line graph. " What do you mean by this?


What do you mean by: "I have multiple graphs that I would like to update
from this main table using named tables." I suppose you could give the
table more than one name but its still the same table, so why give it
multiple names?

--
Cheers,
Shane Devenshire


"J Austin" wrote:

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