Forum Discussion
Linking between sheets on a network suddenly not working
So I have a dashboard at work that links a load of individual sheets
currently - no way i know is refreshing data between sheets
I reference cells via xlookup to catch data when it moves and also ensure that the link is wrapped around a volatile formula so i know the computer is prompted to refresh the function a little more robustly
now i understand that the best way to refresh the dashboard i have found is simply to close and reopen, triggering the "do you want these cells to be updated" prompt
Failing that, i also know where all the options to refresh data on the Data tab on the main options ribbon
i'm actually straight up copying the formula in and out of the cells and the update is still not triggering
the only thing that works is currently rewriting the xlookup from scratch which is bonkers and undermines the entire strategy
is this a fault to the recent outtage? this is going to completely ruin my week if that's the case or my work on going if it's a new "feature".
1 Reply
- Activate the Formulas tab of the ribbon. Make sure that Calculation Options in the Calculation group is set to Automatic.
- Look at the status bar at the bottom of the workbook window. Do you see Circular References? If so, there are formulas that refer directly or indirectly to the cell they are in. That prohibits recalculation. Try to find which cells cause the error and correct them.
