I have a large file /size more than 4mb/ which has more than 300 sheets. There are simple links from sheet to sheet, which refer to a cell from anther sheetand they doesn't work. You have to enter to the forumla bar of the cell and press enter and only after that it returns the correct value.
I have already checked in theFormulas in the "Options",it's not manual, it's automatic.