Microsoft KB Archive/827295

= How to Configure Excel 2003 to Use Microsoft OLE DB Provider for OLAP Services 7.0 =

Article ID: 827295

Article Last Modified on 2/5/2007

-

APPLIES TO


 * Microsoft Office Excel 2003

-



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  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:

 

 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.</ol>

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

Keywords: kbhowto KB827295

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.