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...
- 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.