You receive an error when you create an OLAP cube-based PivotTable in Excel 2003 (887297)


The information in this article applies to:

  • Microsoft Office Excel 2003
OfficeNet:192477OfficeNet:190690OfficeNet:190610OfficeNet:175678OfficeNet:175011OfficeNet:173597OfficeNet:161892OffBug:6253Office 10:346016Office 10:347353Office 10:348055Office 10:348199office9:267850office9:268056plato7x:13543
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 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 completed the following steps when you created the OLAP cube-based PivotTable in Excel 2003:
  • You selected 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 2003 remain.

When you establish a connection for any OLAP PivotTable, Excel 2003 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:
  1. Click Start, and then click Run.
  2. Type regedit, and then press ENTER.
  3. Expand HKEY_CURRENT_USER, expand SOFTWARE, expand Microsoft, expand Office, and then expand 11.0.
  4. Expand Excel, and then click Options.
  5. On the Edit menu, point to New, and then click DWord Value.
  6. Type OLAPUDFSecurity to enter the name for the new registry entry, and then press ENTER.
  7. Double-click OLAPUDFSecurity, type 1 in the Value data box, and then click OK.
  8. Quit Registry Editor.
Modification Type:MajorLast Reviewed:12/1/2004
Keywords:kbtshoot kbprb KB887297 kbAudEndUser kbAudITPRO
©2004 Microsoft Corporation. All rights reserved.