Hey all,

Hoping someone can help me with this issue. I have a metrics file that I'm creating for my team at work. I've done this kind of thing in the past and it's always worked fine, but for some reason this file isn't recognizing values in two separate files saved on a shared drive (this file is also on the same shared drive).

I have a "suspended charges" file and a "failed charges" file that loads daily data of charges and then as the other members on my team resolve them, they get moved to a separate tab in their respective files. What this 'metrics' file is attempting to do is pull the data from those files (through the use of COUNTIF statements, not sure if that's relevant), and count up the number of charges that are out there (by day) as well as the number resolved (again, by day).

When the files are open I get values just fine, the equations work like they're supposed to, but if I close them and recalculate (either through F9 or by entering a new value in a cell), all cells of the affected closed document change to #VALUE.

When I reopen the files, they change from #VALUE to the expected values.

I can't figure out why. Is it a network access thing? Like suddenly Excel has lost the ability to independently access these files? It's never been an issue before.

• When I go into "Edit Links" it tells me the links are "OK".

• These are shared files, but I tried unsharing them ("old" share, we don't use the shitty cloud sharing system) they still didn't work.

Any ideas?