I have looked through other answers but it appears that my problems are addressed only partially, as the issues are across multiple issues.
BACKGROUND
Every month, a workbook is opened with links to external data and reports are run for each site.
The file updates as each site is accessed from...