title: Excel - saving Workbook very slow
body: <p>I have a number of workbooks that are particularly slow when I save them (10 - 30 mins). I know the reason that they are slow is because they have lots of INDEX, MATCH formulas which are linking to another, closed workbook.</p>
  
  <p>The workbook takes 19 seconds to open and about 10 seconds to recalculate when a date is changed (before improvements, recalculation time was about 50 seconds). I just can't seem to speed up the saving time of the workbook.</p>
  
  <p>I have tried to find a way to replace the INDEX, MATCH formula's with VBA code that imports the data when a change is detected, but apparently it isn't possible to import data from a closed workbook, so that doesn't work for me.</p>
  
  <p>I did have the formula's set up as =INDEX( , MATCH( , , )) However I have changed this to have a MATCH column and then lots of INDEX formulas, this has cut the recalculation time down to a fifth of what it originally was and the opening time in half, but if anything the saving time is longer.</p>
  
  <p>Does anyone have any suggestions?</p>