Excel 2010 - Having external links automatically update
Posted on 2013-02-04
I can't seem to get external links to update automatically in Excel 2010. When I open a dependent workbook without having the source workbooks (three of them) open, I want the system to either automatically update the links or prompt me to update them. I do not want to have to go into the Data tab, click Edit Links, and then click Update Values. But that's all I can get to work without having any of the source workbooks open. I did have one of my source workbooks open and then opened the dependent workbook, and it did update my values then, but I shouldn't have to have any source workbooks open in order to update my dependent workbook. I've tried the different options under the "Startup Prompt" option. And I've played with the "Update links to other documents" and "Save external link values" under File, Options, Advanced, but can't get it to work. I want it to work how it did in the older version where when I open a dependent workbook, I want it to stop and ask me if I want to update the links. I could live with the system automatically updating my links as well, but I can't get either one to work. I do have all my files saved in the new .xlsx format. They came from an older version of Excel - not sure if that's part of my problem or not. HELP!!!