Yes, it's because of all the complex formulas. If you want to quicken things up your either need to adapt a new structure of your workbook, adapt a different approach to the formulas used or implemet macros to do the work instead. Perhaps you should change the workbook to something simpler and less dynamic.