Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
EXCEL 2007 - 15 minutes to open workbook
I created a workbook with two main sections 400 rows, 40 coumns with
data being retrieved usning CUBE formulas. I have about 15 macros in the spreadsheet and another sheet that uses alot of vlookups. It takes over about 15 minutes to open the workbook, but a few seconds to save and close. Excel opens up right away, it is just this file. Once the file is open there is no speed issues at all. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
EXCEL 2007 - 15 minutes to open workbook
On Jul 1, 4:52*am, dr wrote:
I created a workbook with two main sections 400 rows, 40 coumns with data being retrieved usning CUBE formulas. *I have about 15 macros in the spreadsheet and another sheet that uses alot of vlookups. *It takes over about 15 minutes to open the workbook, but a few seconds to save and close. *Excel opens up right away, it is just this file. Once the file is open there is no speed issues at all. Try to open any other small file and see if you face the same problem. Try opening a file with only one cell containing data text. Is this also give same problem? Regards, Madiya. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
EXCEL 2007 - 15 minutes to open workbook
dr wrote:
I created a workbook with two main sections 400 rows, 40 coumns with data being retrieved usning CUBE formulas. I have about 15 macros in the spreadsheet and another sheet that uses alot of vlookups. It I have not seen any massive slowdowns with VLOOKUPs myself. I suggest you scale down the problem to something that takes about 10s to load like 4 rows of 40 columns to try and isolate and optimise the timing behaviour. The only places I have experienced massive slowdowns are where drawing graphs and charts are involved using somewhat larger datasets than this. takes over about 15 minutes to open the workbook, but a few seconds to save and close. Excel opens up right away, it is just this file. Once the file is open there is no speed issues at all. It sounds like something fishy in the data loading step then. Regards, Martin Brown |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
EXCEL 2007 - 15 minutes to open workbook
Try Tools, Options, Calculatons, change to Manual.
Close and reopen the file. See if that makes it faster. Go back to automatic after it opens. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Workbook does not open by default in Excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2007 - Workbook.Open Question | Excel Programming | |||
Save workbook every 5 minutes in Excel 2007 | Excel Discussion (Misc queries) | |||
How do I open a workbook automatically in Excel 2007/Vista | Excel Discussion (Misc queries) | |||
How can excel 2000 users open a 2007 .xlsm workbook | Excel Worksheet Functions |