How to Configure Excel 2003 to Use Microsoft OLE DB Provider for OLAP Services 7.0 (827295)

Important This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 Description of the Microsoft Windows Registry

SUMMARY

If you configure a Microsoft Online Analytical Processing (OLAP) query to use the older version of Microsoft OLE DB Provider for OLAP Services, Excel 2003 continues to use Microsoft OLE DB Provider for OLAP Services 8.0.

This article describes how to configure Excel 2003 to use the older version of Microsoft OLE DB Provider for OLAP Services.

MORE INFORMATION

Microsoft Office 2000 and all stand-alone versions of the Office 2000 products include the 7.0 version of Microsoft OLE DB Provider for OLAP Services. To configure Excel 2003 to use the older version, add the MSOLAPVersionDependent entry to the registry. To do so, follow these steps.

WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk. Follow these steps, and then quit Registry Editor:

Click Start, click Run, type regedit, and then click OK.
Locate and then click the following key in the registry:
HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Options
On the Edit menu, point to New, and then click DWORD.
Type MSOLAPVersionDependent, and then press ENTER.
On the Edit menu, click Modify.
Type 1, and then click OK.

Note You must restart Excel 2003 for the change to take effect.