dbTalk Databases Forums  

****PROBLEM WITH EXCEL ...HELP PLEASE*****

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss ****PROBLEM WITH EXCEL ...HELP PLEASE***** in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jose Penafiel
 
Posts: n/a

Default ****PROBLEM WITH EXCEL ...HELP PLEASE***** - 10-01-2003 , 02:09 PM






I not copy formulas in excel xp when using olap pivot table because repeats
and this appears :

=GETPIVOTDATA("[Measures].[Unid
Empacadas]",$A$3,"[Cod_Referencia]","[Cod_Referencia].[All
Cod_Referencia].[L-00041]","[Corrida]","[Corrida].[All
Corrida].[000004]")/GETPIVOTDATA("[Measures].[Velocidad]",$A$3,"[Cod_Referen
cia]","[Cod_Referencia].[All
Cod_Referencia].[L-00041]","[Corrida]","[Corrida].[All Corrida].[000004]")

Regards



Reply With Quote
  #2  
Old   
Lutz Morrien
 
Posts: n/a

Default CubeCellAddin - 10-02-2003 , 04:09 AM






Hi,
Look for the OLAPCubeCellValue Excel addin. I think it is
a Microsoft addin. It solves the problem of copying the
formula instead of the value.

HTH Lutz

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.