title: Macro slow when other Excel files are open
body: <p>I've seen other users post somewhat the same question, but the core problem doesn't seem to be the same (as far as I can tell).</p>
  
  <p>I have an Excel workbook that goes through about 80 000 rows and four columns of data. This takes about 1-2 seconds at the most. The workbook does do operations in other worksheets but for the test I have turned those subs off. If I open an .xlsx of about 10 Mb it takes a bit longer but not much. If I open up an .xlsm with some considerable code, it takes about 6-7 seconds to do the same thing.</p>
  
  <p>What I have read so far is that one should use set variables of ranges instead of cell references, calculation set to manual, screenupdating off. None of these seem to do the trick though.</p>