Multiple Reference Not Updating

[jynlude]

Hi all, new guy on this forum, but have used the search resource pretty extensively to no success

I have a (A) master summary excel 2010 (xlsx) worksheet linking 29405 individual cells to about (B) 34 individual reporting worksheets (xlsx). On each of these (B) individual worksheets, they each link to (C) multiple testing worksheets in xls format.

In general, it's info feeding from (C)->(B)->(A). All the information feeding from (C)->(B) link fine and are updated automatically. However, I have seemingly random fields not being updated in my master summary (A), which link to only cells in (B).

I understand that it's a reference of a reference, but it'd make a lot more sense if all weren't being updated on (A) vs. some.

I've checked my settings and everything is set to auto calculate and I've tried to force recalculate (alt + ctrl + f9) without success. When I do some tests to link (A) directly to (C), it works fine, but this would prompt me to update many cells that break the methodology I'm trying to set with these 3 different kinds of spreadsheets.

The 1 suspicion I have while doing some investigation is that users are taking copies of (C), putting them on their desktop, manipulating it, then reuploading to the shared drive. The (B) worksheets still are reporting accurately though regardless of whether or not they've done this.

*edit* - I determined that while (B) will update fine, if I save (B) with the most up to date values, and close it (or leave it open), (A) will be updated. This tells me that for some reason, (A) is not checking the latest saved record for (B)?

Any insight would be much appreciated.