We are having an issue with an Excel spreadsheet that is linked to several Excel documents in a document library. Mutliple staff members update several "sub" spreadsheets with information that is rolled up to the "master" spreadsheet. Excel appears
to behave correctly in that if I open both the sub and master spreadsheets in my Excel window at the same time, the data in master gets updated. If I just open the master, I have stale data. I'm not sure SharePoint is to blame here, so I'll post
this in the Excel forums as well, but any information or experience anyone has had with this would be fantastic.
Thanks in advance for any help/advice!
View Complete Post