D
DataAnalystWill
I am using Office XP and Access. I have a large table stored in a comma
delimited file that has too many rows to open in Excel. I successfully
imported to table to Access. I then was creating a Pivot Table using the PT
Wizard and got the following message,"An error occurred while trying to use
the Microsoft Excel Pivot Table wizard. Microsoft Excel returned the
following error: 'Problems obtaining data.'". How can I troubleshoot this
problem? Any ideas what the cause is?
delimited file that has too many rows to open in Excel. I successfully
imported to table to Access. I then was creating a Pivot Table using the PT
Wizard and got the following message,"An error occurred while trying to use
the Microsoft Excel Pivot Table wizard. Microsoft Excel returned the
following error: 'Problems obtaining data.'". How can I troubleshoot this
problem? Any ideas what the cause is?