locked
Can I perform writeback operations in Excel 2007? RRS feed

  • General discussion

  • [This is just for sharing information for those common asked questions collected from forums. If you have any better way or feedback, please directly reply in this thread so that community users can benefit from your answers.]


    Question:
    I want to directly perform writeback operations in Excel 2007, but I have not found a way to do it.
     
    Answer:
    No. Excel 2007 does not support writeback to SSAS database. You have to manually run "UPDATE CUBE" statement for writeback.  Writeback is supported in Excel 2010.
     
    Using Cube Writebacks (MDX)
    http://msdn.microsoft.com/en-us/library/ms145568.aspx
    Excel 2010 PivotTable What-If Analysis (Writeback)
    http://blogs.msdn.com/b/excel/archive/2009/10/12/excel-2010-pivottable-what-if-analysis.aspx


    Please remember to mark the replies as answers if they help and unmark them if they provide no help
    Friday, June 25, 2010 3:50 AM