Excel Writeback

Posted on 2008-11-10
Last Modified: 2016-02-13
Hi !

I created writeback enabled cube and dimension in BIDS. How can I writeback dimension and cube measure in Excel?

Question by:iFiona
    LVL 20

    Expert Comment

    HI Fiona,
    Are you using Excel 2003 or Excel 2007? I dont think at this time Excel 2007 supports writeback.  Your best bet would be use VBA and code it in.
    There is a very good online resource written by Charlie Maitland (see attached link) which would be helpful to you.
    I am sorry that I cannot help you further on this,
    LVL 20

    Accepted Solution

    If you are using Excel 2003, then I can point you to the following resource

    Author Comment

    Thank you so much! You have been a great help!

    I did try the Excel 2003 Add-in. It supports the writeback for cube but not for dimension. Dimension writeback is what I'm looking for.

    I am looking for writeback solution for Excel 2007 as well. Any thoughts?

    The Charlie Maitland's link you provided, I 'm totally new in the VBA or ADO, do you have reference how to use Charlie's sample code? a starting point?


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
    Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
    This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
    This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now