Excel Calculation taking too long

D

Doris

I created an excel sheet with a lot of web queries and calculations. It is
taking 30 minutes to complete the downloads and calculations. I thought I
could cut this run this time down by turning calculation to manual and
hitting F9 at the end of the run. However, this is only saving about 5
minutes. How can I cut the execution time down?
 
D

Don Guillett

Perhaps your procedure could be more efficient. If you like, send your
workbook to my address below and I will take a look.
 

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

Turning off automatic calculation 0
Stop Auto Calculation Q 15
Cannot open any folders (pinned or recent) from Word 365 Open Dialogue/Backstage 0
Start a mail merge upon opening the document 1
Date Calculation - Astro Calculation 0
VBA Calculation - taking forever 1
Calculation Time 2
Data Entry very slow ... Slow to start WOrksheet_Change 4

Top