| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Calculation taking too long
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Calculation taking too long
Perhaps your procedure could be more efficient. If you like, send your
workbook to my address below and I will take a look. -- Don Guillett Microsoft MVP Excel SalesAid Software "Doris" wrote in message ... 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel to pdf taking too long in 2007 | Excel Discussion (Misc queries) | |||
| Excel to PDF taking too long | Excel Discussion (Misc queries) | |||
| calculation taking too long | Excel Worksheet Functions | |||
| Cell Calculation taking to long | Excel Programming | |||
| Problem with formula - Taking too long for calculation | Excel Programming | |||
Linear Mode
