Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I am working on an Excel 2007 workbook (less than 1gb in size). There is one sheet which has formulae linked to other two sheets in the same workbook. The problem is that it becomes really slow whenever I make any change (or update the data in the other two sheets). I am using Intel i5 Windows 7 OS with 8gb RAM (which I think should be more than enough for this kind of work). Please help!

share|improve this question

2 Answers 2

The less than 1 GB in size is worrisome, as if you're nearing a 1 GB excel file. Excel is notoriously slow with large files. If you have a lot of formulas updating due to links, it will bog down.

What you can do is go to file (button) - options and go to the formulas section and change the calculation options to manual. Now it will only update when you press F9 so you can control when it gets slow.

share|improve this answer

You can temporarily disable recalculations. Go to Excel Options, then Formulas, and under Calculation Options set Workbook Calculation to Manual.

To manually recalculate press F9

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.