Pivot Table from Access DB
I'm dealing with a spreadsheet which will soon exceed the number of allowable
rows. I've found that using a Pivot Table is a great way to organize and
analyze all of this data.
I thought I'd be clever by importing the data to Access and create a table,
then go into Excel run the Pivot Table using external data, select the table
in my database, and do my thing. But, I get a query error in Excel saying it
can't access the table.
Why not?
|