I have both Access 97 and Access 2000 installed on my PC. 99% of the time they work perfectly together.

When I create a pivot table form in Access 97, it wants to use Excel 2000 for viewing and editing.

How can I force the Access 97 pivot table to open in Excel 97?

Thanks in advance.