Help with Pivot Table Error in Access 2000

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?
Who is Participating?
balatheexpertConnect With a Mentor Commented:
hello, access 2000 will have the object model of that version and the earlier ones. Hence, it can not refer or support Excel 2010 and so comes this issue. Either you have to install Excel 2000/prior on your machine or upgrade Access to the latest version!!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.