### spreadsheet grinding to a halt.. help please, please ...

Nov 16, 2009· I suppose you could have a cell on the summary sheet which could contain two values (ie Formulas or NoFormulas) and based on the worksheet_change event you could do the copy+pastespecial values on the formulas you want overwritten with values (keeping the first row, then using this row to copy the formulas down if the Formulas option was selected).