I have a sheet that collects data from pre-defined cells in workbooks that are on a network drive.
When I open the sheet that collects the data the update-or-not question pops up and I choose update.
Still, the values are not updated.

I press F9 to calculate manualy but that does not update the values.

When I select one of the not updated cells and press F2 and then enter the cells updates. Very quick so it seems like the actual value is in RAM memory.

Is there a setting in preferences I must change or do you know any other solution?