Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
45 seconds to open a file
Office 2007:
If I open Excel it starts very quickly (about 1 second). If I then click on an Excel file it opens very quickly (about 1 second). BUT if I clcik on an Excel file before opening Excel then the excel frame shows up quickly followed by a long (30-45 seconds) pause before the spreadsheet shows up. What is going on to cause this? It is not spreadsheet size - I can do this with a 20Kb file with no macros or other complications. happens with xls or xlsx files. I do load personal.xls with some custom macros which display on the menu as executable buttons but they are loaded when Excel loads (which takes 1 second) so shouldn't be the problem. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
45 seconds to open a file
We've been having this problem, too. (See below, from 5/29/08.) Any ideas
or help would be appreciated. Thanks! -C It's been happening in my 2007 version, too. I have to click on the office button before anything opens. I'd also appreciate any suggestions. (Sorry, Jambo, to not be any help to you, but you do have my sympathy/support!) "Jambo" wrote: Hi, This is a strange one. If I double click on a saved Excel 2003 workbook (saved on my desktop), it takes ages to open and then will hang. If I open Excel then select the workbook, it loads immediately. Has anyone any ideas on this one? Running XP Pro "Lorne" wrote: Office 2007: If I open Excel it starts very quickly (about 1 second). If I then click on an Excel file it opens very quickly (about 1 second). BUT if I clcik on an Excel file before opening Excel then the excel frame shows up quickly followed by a long (30-45 seconds) pause before the spreadsheet shows up. What is going on to cause this? It is not spreadsheet size - I can do this with a 20Kb file with no macros or other complications. happens with xls or xlsx files. I do load personal.xls with some custom macros which display on the menu as executable buttons but they are loaded when Excel loads (which takes 1 second) so shouldn't be the problem |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
45 seconds to open a file
Turn off your anti-virus software and try it again?
John "Lorne" wrote in message ... Office 2007: If I open Excel it starts very quickly (about 1 second). If I then click on an Excel file it opens very quickly (about 1 second). BUT if I clcik on an Excel file before opening Excel then the excel frame shows up quickly followed by a long (30-45 seconds) pause before the spreadsheet shows up. What is going on to cause this? It is not spreadsheet size - I can do this with a 20Kb file with no macros or other complications. happens with xls or xlsx files. I do load personal.xls with some custom macros which display on the menu as executable buttons but they are loaded when Excel loads (which takes 1 second) so shouldn't be the problem. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
45 seconds to open a file - update
1. It is nothing to do with anti virus - same time regardless of whether the virus software is running.
2. Clicking the office button top left of the Excel Form displays the spreadsheet instantly. Hence I conclude this is a programming error for Microsoft to sort out. "Lorne" wrote in message ... Office 2007: If I open Excel it starts very quickly (about 1 second). If I then click on an Excel file it opens very quickly (about 1 second). BUT if I clcik on an Excel file before opening Excel then the excel frame shows up quickly followed by a long (30-45 seconds) pause before the spreadsheet shows up. What is going on to cause this? It is not spreadsheet size - I can do this with a 20Kb file with no macros or other complications. happens with xls or xlsx files. I do load personal.xls with some custom macros which display on the menu as executable buttons but they are loaded when Excel loads (which takes 1 second) so shouldn't be the problem. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to Change Hours:Minutes:Seconds to Seconds only | Excel Discussion (Misc queries) | |||
In Excel - Use Windows Explorer instead of File Open to open file | Excel Discussion (Misc queries) | |||
Converting Julian Seconds with a macro to replace old seconds data | Excel Discussion (Misc queries) | |||
Excel showing old or new version of file for 2 - 3 seconds | Excel Discussion (Misc queries) | |||
Convert "Time Interval" in "hours : minutes : seconds" to seconds | New Users to Excel |