locked
Update Function New PowerPivot 2012 RRS feed

  • Question

  • Dear all,

    will it be possible to update my pivot table source data in Excel client or via Macro? As currently I have to update the data first in Power Pivot window and then again in Excel client to reflect updated data of my SQL server.

    Thanks in advance

    Stefan

     

    Tuesday, January 10, 2012 12:40 PM

Answers

  • Hi Stefan_T,

    There is such kind of build-in feature to support writeback in PowerPivot currently, to work around the issue, you can refer to Ken Puls's blog at this link http://www.excelguru.ca/blog/2011/03/10/write-back-using-powerpivot/

    Besides, here I still would recommend you to submit a feedback to Microsoft Connect at this link at this link https://connect.microsoft.com/SQLServer/Feedback This connect site is a connection point between you and Microsoft. Your feedback enables Microsoft to make software and services the best that they can be, Microsoft might consider to add this feature in the following release after official confirmation.

    Regards,
    Challen Fu


    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    • Marked as answer by Challen Fu Wednesday, January 18, 2012 6:21 AM
    Friday, January 13, 2012 7:11 AM