Access Pivot Table Form

[Brian Roberts]

I am trying to create a pivot table form with in MS Access 97 but, I get the following error message: "An error occurred while trying to use the Microsoft Excel Pivot Wizard. Microsoft Excel returned the following error 'Problems obtaining data'" As a result the pivot table form is not created. Any suggestions?