Speeding up workbook calculations

G

Guest

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

Adding a chart to large workbook brings workbook activity to a hal 6
Speeding up Excel calculations 10
Excel Re-calculation 2000 compared to 2003 1
Saving a Worksheet/Workbook with VALUES ONLY 4
F9, Shift+F9, Ctrl+Alt+F9 etc 3
Quicker calculations -- storing huge equations or cutting and past 2
Workbook causes calculation errors 2
Speeding up Excel - Large amounts of data, no complex formulas 3

Top