Logo 
Search:

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

Hi

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.

Thanks

Jamie

Share: 

 

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.




Tagged: