|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 16th, 2004, 04:19 PM
|
|||
|
|||
'client safety options do not allow pass-through' errors
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? 
|
|
#2
September 17th, 2004, 04:51 AM
|
|||
|
|||
|
Probably best to ask questions about Excel in a public.excel group, but
here you a HKCU/Software/Microsoft/Office/11/Excel/Options/OLAPUDFSecurity = 1 HKCU/Software/Microsoft/Office/10/Excel/Options/OLAPUDFSecurity = 1 If there are HKLM values, they problem override the current user setting. (david) "Smarty1949" wrote in message ... 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?
|
|
#3
September 17th, 2004, 02:41 PM
|
|||
|
|||
|
Thank you.
"david epsom dot com dot au" wrote: Probably best to ask questions about Excel in a public.excel group, but here you a HKCU/Software/Microsoft/Office/11/Excel/Options/OLAPUDFSecurity = 1 HKCU/Software/Microsoft/Office/10/Excel/Options/OLAPUDFSecurity = 1 If there are HKLM values, they problem override the current user setting. (david) "Smarty1949" wrote in message ... 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?
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Select Multiple Options | Marie | New Users | 1 | September 8th, 2004 10:55 AM |
| Macro possible? | Nimit Mehta | Worksheet Functions | 5 | June 7th, 2004 10:39 PM |
| How to set "Client Safety Options" in excel | Peter | Setting up and Configuration | 1 | June 2nd, 2004 12:09 PM |
Linear Mode
