ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   45 seconds to open a file (https://www.excelbanter.com/excel-discussion-misc-queries/190188-45-seconds-open-file.html)

Lorne[_2_]

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.



CTURNER82

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


jaf

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.



Lorne[_2_]

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