January 5, 2004 at 3:13 am
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
January 8, 2004 at 1:35 am
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
January 14, 2004 at 8:25 am
"...e il mio maestro mi insegnò com'è difficile trovare l'alba dentro l'imbrunire" F.Battiato - Prospettiva Nevsky
October 21, 2004 at 10:11 pm
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.
October 24, 2004 at 5:28 pm
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.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply