Client Safty Options - Office 2003

[Viggo]

When trying to refresh Pivot Table data, in Excel)
(external data, OLAP Cube) I get the following message:

"Client Safety Options do not allow pass through
statements to be issued to the data source".

Do someone know how to get around this?
Where can I change secutity settings?

I still have a computer with older set-up, Office XP
(2002) and that instalation works fine.

Thanks
Viggo

 

[SA]

Viggo:

Check out this knowledgebase article on SQL Server's OLAP update with
Service Pack 3a

http://support.microsoft.com/defaul...new_pivot_table_service_restricted_clien_cuy1

It may discuss exactly what is happening.

It also discusses ways to modify the behavior.

Steve Arbaugh
MS Access MVP