A
Authorized User
I've created PivotTables for years from Excel spreadsheets and
external data using Office 2000 and 2002. No problems. I try this
feature out on a new XP Pro machine with Office 2003 Pro and when I go
to create a PivotTable within Excel using external data (I want to
link to an Access file), I click on the Get Data button, and the only
thing that happens is in the bottom left hand corner of the
spreadsheet it states "waiting for data to be returned from Microsoft
Query" for a few seconds and then stops. Nothing else happens. The
program isn't frozen, I can cancel out. Why does Excel just sit there
at this point?!? Something wrong with my ODBC setup?
Your words of wisdom are appreciated.
external data using Office 2000 and 2002. No problems. I try this
feature out on a new XP Pro machine with Office 2003 Pro and when I go
to create a PivotTable within Excel using external data (I want to
link to an Access file), I click on the Get Data button, and the only
thing that happens is in the bottom left hand corner of the
spreadsheet it states "waiting for data to be returned from Microsoft
Query" for a few seconds and then stops. Nothing else happens. The
program isn't frozen, I can cancel out. Why does Excel just sit there
at this point?!? Something wrong with my ODBC setup?
Your words of wisdom are appreciated.