Excel 2010 External links do not update unless source file is open
Posted on 2014-12-29
I have a master workbook with tabs to 12 different spreadsheets. One tab for each external file. I have created formulas to pull the info into the master and the data is consolidated. All of the formulas work and pull the correct information in. However when I save and close all the spreadsheets and try to only open the consolidated spreadsheet, there is no data. In order to populate the spreadsheet, I have to open all of the individual spreadsheets.
My consolidated spreadsheet will be linked to others, so I need to have the ability to have all the sheets "chained" together and get to the data.
Under Data - Edit Links - Startup Prompt, I have the "Don't display the alert and update links"