Links between worksheets WITHIN same Excel workbook not updating automatically
Posted on 2013-11-01
I am using MS Office 2010, Excel.
I have a workbook that I have been using for several years, created in Office 2003 but it has seemed to be OK withing Office 2010. It has many worksheets and links between those worksheets (but all within the same workbook). These inter-sheet links have stopped working unless I click on the formula bar of the cell in question and hit Enter.
I have checked that Calculation is set to Automatic. I have closed and reopened Excel. A colleague experiences the same problem with the same workbook. Links within a worksheet seem to update as expected, it is only links to other worksheets within the same workbook that do not work.
Is the file corrupt or is there a fix? Please help!