Microsoft KB Archive/887297

= You receive an error when you create an OLAP cube-based PivotTable in Excel =

Article ID: 887297

Article Last Modified on 1/18/2007

-

APPLIES TO


 * Microsoft Office Excel 2007
 * Microsoft Office Excel 2003

-





Important This article contains information that shows you how to help lower security settings or how to turn off security features on a computer. You can make these changes to work around a specific problem. Before you make these changes, we recommend that you evaluate the risks that are associated with implementing this workaround in your particular environment. If you implement this workaround, take any appropriate additional steps to help protect your system.

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



SYMPTOMS
When you try to create an On-Line Analytical Processing (OLAP) cube-based PivotTable in Microsoft Office Excel 2007 or in Microsoft Office Excel 2003 with the OLAP Cube Wizard, you receive an error message that is similar to the following:

Client safety options do not allow pass through statements to be issued to the data source.

You receive this error message if you complete the following steps when you create the OLAP cube-based PivotTable in Excel:
 * You select one of the following options in step 3 of 3 in the OLAP Cube Wizard:
 * Rebuild the cube every time the report is opened, and retrieve the data for the cube only when needed.
 * Rebuild the cube every time the report is opened, and retrieve all data for the cube at once.
 * You clicked Finish in step 3 of 3 of the PivotTable and PivotChart Wizard.



CAUSE
This issue occurs because of a security setting in OLAP access that only allows for connections to trusted resources.

This setting has no user interface.



WORKAROUND
Warning This workaround may make your computer or your network more vulnerable to attack by malicious users or by malicious software such as viruses. We do not recommend this workaround but are providing this information so that you can implement this workaround at your own discretion. Use this workaround at your own risk.

Warning If you use Registry Editor incorrectly, you may cause serious problems that may require that you 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.

To work around this issue, you must set the OLAPUDFSecurity registry entry to 1. If you set the OLAPUDFSecurity registry entry to 1, the safety feature in OLAP is disabled. However, the safety features of Excel remain.

When you establish a connection for any OLAP PivotTable, Excel will prompt you with a message that warns you that you should only continue if you trust the owner of the resource.

To set the OLAPUDFSecurity registry entry to 1, follow these steps:  Exit Excel. Click Start, click Run, and then click OK. Locate and then click one of the following registry subkeys:

Excel 2007

 

Excel 2003

 

 After you select the subkey that is specified in step 3, point to New on the Edit menu, and then click DWORD Value. Type OLAPUDFSecurity, and then press ENTER. Right-click OLAPUDFSecurity, and then click Modify.</li> In the Value data box, type 1, and then click OK.</li> On the File menu, click Exit to quit Registry Editor.</li></ol>

Additional query words: XL2003 XL2007 queries kbnoOfficeAlertID

Keywords: kbquery kbexpertiseinter kbtshoot kbprb KB887297

-

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

© Microsoft Corporation. All rights reserved.