Linked sheets not auto updating in MOSS 07 RRS feed

  • Question

  • Hi all,

    Currently, I have 12 separate spreadsheet files sitting in a document library, along with a 13th file that has has links to the other 12 sheets configured.  This file rolls up the data from the other 12 files and displays it on the spreadsheet.  The issue I'm running into is if a person updates one of the 12 files, the data isn't updated on the roll up file unless I open the file, go to Data - Edit Links, and select update links.  Is it possible to have this auto update when the roll up file is opened?  I believe this is an issue with SharePoint and not Excel.

    Thanks for your help!
    • Moved by Mike Walsh FIN Tuesday, February 1, 2011 9:00 PM seems to be Excel+SharePoint not Excel Services (From:SharePoint - Excel Services (pre-SharePoint 2010))
    Tuesday, February 1, 2011 6:27 PM

All replies