'client safety options do not allow pass-through' errors

S

Smarty1949

Have a multisheet Excel book that has many macros that refresh pivot tables
built from OLAP Cubes. The pivot tables actually refresh the OLAP Cubes. I
have started getting 'client safety options do not allow pass-through'
statement is issued and the pivot table cannot be refreshed.

I can use MS Query to refresh the Cube, but there are hundreds of these
cubes in this application & Excel offers the quickest way to solve this
problem.

Any suggestions?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Affect a new connection to a pivot table 0
Client Safety Options don't allow pass through statements to data. 1
Excel 2003 Client Safety Options 0
client safclient safety options do not allow pass through statemen 0
Client Saftey Option in Excel 2003 0
Excel 2003 Client Safety Options 0
Pivot Table Row Label has been changed and won't change back 0
Excel Client Safety Options 0

Top