View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Johan N Johan N is offline
external usenet poster
 
Posts: 1
Default OLAP: Security Error when updating a Cube

Hi

I have a problem with a OLA-cube I'm tryig to build in excel.

I Have no problem with building the cube and get the data to Excel for the
first time but when i try press the Update-button i recieve the following
error (translated from swedish): The alternatives for client security do not
allow for pass-through expressions being given to the datasource.

Does anyone know where to start to debug this? I have looked in the
ODBC-properties, tried to set macro security to low but it doesn't help. I
cannot find anything on this topic on Google either.

I tried it on two comuters running Windows XP with Office 2003.


If I build a plain pivot-table It works.

(The message in swedish if anyone recognises it: Alternativ för
klientsäkerhet tillåter inte att pass through-uttryck ges till datakällan.)

Any help or ideas would be appreciated.


/Johan