OLAP writeback from MS Excel

• Rasbaba

  Old Hand

  Points: 305

  More actions

  January 5, 2004 at 3:13 am

  #106969

  Hi There,

  I've created a write-enabled budgeting cube but am not able to writeback from Excel. I've copied the various code samples from the spreadsheets posted on the MS site but still no luck; still getting the 'Cannot change this part of a Pivot Table report' message.

  Any help will be much appreciated.

   

  Thanks

  Andre

   

• Nico Verbaenen

  SSChasing Mays

  Points: 649

  More actions

  January 8, 2004 at 1:35 am

  #489085

  Andre,

  A few weeks back I went to microsoft where they presented excel OLAP reporting, a part of the new office Solution Accelorator.

  One of the new features was to be able to write back to a cube.

  So I guesse you arn't able to write back with current versions of excel.

  This new version will become public beta Jan/Feb 2004.

  I'll keep you posted when it is public.

  greetings,

  Nico

• gaetano.lombardo

  Mr or Mrs. 500

  Points: 549

  More actions

  January 14, 2004 at 8:25 am

  #489983

  Hi Nico,

  do you know where I can see features of this new product "Excel OLAP reporting" ?

  thank's in advance,

  Marco.

   

  
  "...e il mio maestro mi insegnò com'è difficile trovare l'alba dentro l'imbrunire" F.Battiato - Prospettiva Nevsky

• grant marlow

  SSC Enthusiast

  Points: 199

  More actions

  October 21, 2004 at 10:11 pm

  #527574

  record a macro. select the pivot table. stop recording. step into the macro. change the pivotselect to enabledatavalueediting

  should be something like:

  Sub Macro1()

      

      ActiveSheet.PivotTables("PivotTable1").EnableDataValueEditing

  End Sub

  step thru the macro.  for code to handle the updates, get the 'extending olap ...' download from MS and adapt the writeback module.

  good luck!

  BTW, this is a good way to learn how to program excel.  use the record macro when you create the pivottable to find out how to change the datasource too.

• stevefromOZ

  SSC-Forever

  Points: 43646

  More actions

  October 24, 2004 at 5:28 pm

  #527762

  Whilst waiting on the new excel stuff from MSft, you could try using the current accellerator/add-in -> http://www.microsoft.com/downloads/details.aspx?FamilyId=DAE82128-9F21-475D-88A4-4B6E6C069FF0&displaylang=en

  The download button should be at the top right.

   

  Steve.