Feedback by UserVoice

Jenny

My feedback

  1. 4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Jenny commented  · 

    Hi Lee! I submitted a ticket to Microsoft Support and kept being passed around between Excel desktop support and Sharepoint/Excel web app support and neither were able to help with the issue. Eventually I gave up when it was clear they would not assist and just kept pointing fingers between the two systems. I am no longer using this spreadsheet and the summary was hosted on a different user's computer, but here is what I recall we did as the workaround. That user would open the summary spreadsheet (locally) and navigate to the data tab. He would click Edit Links and then click Update Values. I believe this cleared the "source not recalculated" error. You can use ctrl or shift to highlight multiple source links at once or use ctrl-A to highlight them all. In our case, the workbook would freeze if he tried to update all at once so he would go through and "update values" on like 10 sources at a time. Hope this helps!

    Jenny shared this idea  · 
  2. 9 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Excel for Windows (Desktop Application) » Other  ·  Flag idea as inappropriate…  ·  Admin →
    Jenny supported this idea  · 

Feedback and Knowledge Base