Speeding up workbook calculations

J

John

I have a number of workbooks that contain worksheets of data imported from
our company's ERP system using MSQuery. The analysis of this data uses a
number of vlookup functions to associate data across the worksheets. The
workbook takes a long time to calculate - upwards of 5 minutes for some
workbooks. Does anyone have "hints and tips" for speeding up the
calculations.
- Calculation is set to "manual" in the workbook options
- PC is 1.6 GHz
- Windows task manager indicates 100% CPU useage during calculation.
TIA.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel not responding before calculations 1
Combine multiple workbooks into one workbook 3
Speeding up Excel calculations 11
import multiple excel books to one excel workbook 3
Adding a chart to large workbook brings workbook activity to a hal 6
Excel 2003 Calculation Time with multiple sheet and linked workboo 0
maximum calculations per excel workbook? 1
Spreadsheet design 1

Top