I have an excel file (File A) that's downloaded from a company resource server. It has cells which reference data in a different file (File B) on that server. The File A cells reference the File B data in a format that looks like this:
When File A opens, it's not updating the value in this cell with the value from File_B. I've turned on every Excel 2010 option I can find that should allow external links to work. This works fine in Excel 2007.