My office is pilot testing a conversion to Office 2010 and I've noticed an issue in Excel that wasn't present in our 2007 installation. I'm getting #Value errors in any cell that references an unopened linked spreadsheet. I can open the linked spreadsheet to resolve the issue but this isn't the most desireable solution.
It's odd that we didn't have this issue in 2007. Co-workers not in the test group are still running Excel 2007 and they can open the same file without the #value errors. I do have "Enable automatic update for all workbook links" checked and I realize this adds to the problem but I'm hoping there is another setting that we can modify to get back to the 2007 functionality. Any ideas?