'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?
 
Top