locked
Broken link in PowerPivot for Excel RRS feed

  • Question

  • Hello,

    An error occured in Excel and the link between PowerPivot and the Excel table is broken. Is it possible to set up the link again? Or do I need to establish the link from the begining?

    Friday, February 21, 2014 7:12 AM

Answers

  • Hi Omer,

    This has happened to me before on a few occasions. In my experience it's meant that I've had to remove the table (after copying and pasting any associated measures to a safe location e.g. text file), re-add the table and re-establish the relationships, and then paste my measures back in. At the moment, it doesn't look like there's a quick way to re-establish the link. Hope this gets fixed in a future release.

    Here's an official article that briefly touches on this subject: http://technet.microsoft.com/en-us/library/gg413456.aspx


    Regards,

    Michael

    Please remember to mark a post that answers your question as an answer...If a post doesn't answer your question but you've found it helpful, please remember to vote it as helpful :)



    • Edited by Michael Amadi Friday, February 21, 2014 2:57 PM
    • Proposed as answer by Elvis Long Monday, February 24, 2014 8:09 AM
    • Marked as answer by Elvis Long Monday, March 3, 2014 8:36 AM
    Friday, February 21, 2014 2:55 PM