[Last Call] Learn how to a build a cloud-first strategyRegister Now


Help with Pivot Table Error in Access 2000

Posted on 2011-04-25
Medium Priority
Last Modified: 2012-05-11
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?
Question by:dtw404
1 Comment

Accepted Solution

balatheexpert earned 2000 total points
ID: 35464121
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!!


Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question