Sharepoint 2010 Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint 2010       RSS Feeds

Linking excel files query

  Asked By: Jamie    Date: Jun 03    Category: Sharepoint 2010    Views: 1697


New to sharepoint.

I have one excel file (master sheet) that updates around 30 other excel files that our users are expected to update.

This is working fine. I can update data and it updates the other excel files by updating the links when they are opened.

The problem I'm having is that for some of the excel files, I need them to link and update to a summary excel file. I thought it would work the same way as above, however, when the individual excel files are closed, the summary excel file reverts to #REF! in every cell??

not sure why it works one way, but not with this file??

Any help would be appreciated.





No Answers Found. Be the First, To Post Answer.

Didn't find what you were looking for? Find more on Linking excel files query Or get search suggestion and latest updates.