Hi, my issue is I have an "input workbook" with tabs to enter sales for various countries. This is linked to a spreadsheet for that individual country, and the total sales from that spreadsheet are then linked to a main workbook that has the total sales for each individual country. However, the main workbook does not update the newly entered daily sales unless I open both the "main" workbook and open the "individual country" spreadsheet. The "main" will also not save the updated sales unless I save the "individual country spreadsheet as well.

I'm in the testing phase and have only linked seven of the countries from the "input workbook" to the "individual country" spreadsheets. These are the ones having update issues in the "main" workbook. I have the rest of the countries linked from the "individual country" to the "main" and these are not having the same issue.

I know this may be confusing as i'm not sure how to explain it...Any input would be greatly appreciated!!!