For some reason formulas are not updating, even after refreshing and checking the links and verifying they are accurate. To update the formulas requires going to the formula bar, to the end of the formula and "enter". Even when formulas are copied using the fill handle, they maintain the original cell's data. There are NO absolutes in the formula and it is NOT an array formula. Examples: =C123 (linked to cell on same worksheet) ; =Staff_Hours!E122 (linked to cell on another sheet in workbook); also have formulas for links to other workbooks that are requiring the same attention. Any suggestions to fix this problem are appreciated. Thanks!
Bookmarks