How to open Excel workbook without updating external data sources (but keeping it enabled)?
<p>I have some workbooks, which starts with automatic macros and data refreshing (and, pre-empting some suggestions, these workbooks need to work like that, because I'm starting them automatically from Windows scheduler and I need them to perform tasks without any action on the user's part).</p>

<p>When I need to check/update some formulas, SQL query or layout, I just open a workbook <strong>holding [Shift] key</strong> and it prevents triggering macros in Workbook_Open / Auto_Open events etc., which is great.</p>

<p>The problem is that there are still some external data sources which are automatically refreshed during the opening. In some of these workbooks queries take a long while to accomplish and I need to wait a minute or two before I can edit a workbook.</p>

<p>Is there any way I could open a workbook with both macros and data refreshing disabled? Or, perhaps, any simple way to cancel executing a query?</p>