Trying to use a PivotTable and getting the below error in Access 2000.
"The Pivot Table Wizard can't find Microsoft Excel 97 or Microsoft Excel 9 installed on your system. This is required to create a pivot table."
I have Access 2000 and all other Office is 2010.Office 2000 was removed via upgrade except Access. Will I be able to do this function in Access?