How to troubleshoot "Automatic update of links has been disabled"
Go to Data -> Edit Links (in the Connections group). It will show the linked sources. Unfortunately, Excel has no native way of finding what is linking to the sources (official documentation states: "There is no automatic way to find external references (also called links) that are used in a destination workbook."). It might be a reference in a Cell, which is not hard to find, or in a Chart, which might be (I am actually having trouble in one such case).
I use a very useful add-in, FINDLINK, to find the locations of external links. It worked most of the times, but it is not working in one specific case.
Other options are:
http://www.extendoffice.com/documents/excel/953-excel-list-all-links.html . It gives 3 options: Use the Find command, Use a VBA macro, Use Kutools for Excel.
http://blog.contextures.com/archives/2013/11/12/find-external-links-in-an-excel-file/ . There is overlap with the previous item.
Delete Links Wizard, from Microsoft (it is stated that it APPLIES TO Microsoft Excel 2000 Standard Edition, Microsoft Excel 97 Standard Edition).
I do not know whether Microsoft Office 2010 has the feature to break links, but you can break links with MS Office 2013:
Go to Data -> Connections -> Edit Links -> Break Link
This turns the value into a local value instead of a value from an external source. The warning is gone once you save and re-open the file.
One way to find that would be to click on formulas then click on show formulas check to see nothing is pointing to a different sheet. If there is nothing there then click on formulas then click on name manager and see if there is any formulas referring to a different sheet. Once you fix those save and close and open the sheet and should be all good to go.