PDA

View Full Version : Writeback in Excel Pivot Table: How to repeat MS example?


Stpl
09-20-03, 16:04
Hi Gurus!

I'm a newbie in this area and started work on modeling our tasks on available examples...

In MSDN I found example of using Writeback features in OLAP cube via Excel pivot tables:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnexcl2k2/html/odc_xlextendolap.asp

Good example concerning Writeback BUT: How did they able to change values in Pivot Table???

I've run via all protection, locks, etc. in pivot table in that XLS but still unable to make another table able to change values inside (regardless of write back to cube).

If anyone can give me a hint how to do that, I'll extremely thankful for any information!

Looking forward for any comments
Stanislav Ploschansky