My company is in the process of upgrading to the 2013 Office. I have a spreadsheet created in Excel 2010 with sumifs from another workbook. Currently users (2010) getting into the end file have their prompt to enable content set so that the spreadsheet won't automatically update when opened. The users that have been switched to 2013 have the same prompt but when the click don't update the sheets still try linking back to the sumif file and then show #VALUE. Any ideas on how to get this fixed? Causing us some major issues.