I have a spreadsheet which is linked to 20 other spreadsheets. The 20 source spreadsheets update and save every minute. The deistination spreadsheet also updates the links and saves every minute to pull in the most recent data. Once in awhile it seems that i am getting errors about the links not being able to update. Do you think this is because both spreadsheets are trying to save/update at the same time and that could be causing the error? I notice this issue more frequently on slower running computers. How do I ignore the error and prevent it from stopping the macro? Even is the solution is that it ignores the error but it can still update it on the next minute that would be fine. Here is the code. Thank you in advance. 

Please Login or Register  to view this content.