How to set "Client Safety Options" in excel

[Muneeb]

Hi everyone,

I need a help in excel. Could anyone please tell me what
is "client safety options" in excel and how to set or
unset it...I'm trying to refresh my query in excel and
I'm getting this message. My excel sheet is getting data
from the Microsoft Analysis Services.

Your help will be appreciated.

Thanx.

Muneeb.

 

[ben_chronister]

You need to add this to the connection string:

Safety Options=DBPROPVAL_MSMD_SAFETY_OPTIONS_ALLOW_ALL

This took me way too long to figure ou


-
ben_chroniste

 

[enewhouse]

*You need to add this to the connection string:

Safety Options=DBPROPVAL_MSMD_SAFETY_OPTIONS_ALLOW_ALL

This took me way too long to figure out *

I'm also getting the client safety options error in excel 2003, tryin
to use pivot tables with an olap cube.

I'm still stuck. Not sure where to enter the connection string. Coul
someone who knows provide specific instructions for how to work aroun
this error in excel? Thanks a ton, Eri


-
enewhous

 

[Mark Morrall]

I am having this problem too. I created an OLAP cube in
Excel XP and it worked fine. However, when i upgraded to
2003 I get the "Client Safety Options do not allow pass
through statements to be issued to the datasource" error.
I have tried to add the string suggested to the
connection string (in the .oqy file?) but still getting
the same error message. Does anybody have any ideas?