![]() |
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. |
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 |
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. |
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. |
All times are GMT +1. The time now is 10:38 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com