Excel 2007 - files open slowly

[dennisfrandsen]

Having a strange issue with Excel 2007. When I open an Excel file
(.xlsx or .xls) by double-clicking the file it takes forever to open
(about 60 seconds). If I have an instance of the Excel application open
already, then double-click the file, it opens right away. The problem
only seems to occur if the application is not already running. The
other weird thing is that when it does take a long time to open, the
application does not appear to be "hung". In other words, when I
double-click on the file, the Excel application opens right away, but I
have to wait for about a minute before the actual worksheet appears. In
the meantime, the application itself seems responsive. I can click on
the menus, etc without any problem.

Anyone else experienced this problem?

 

[CLR]

Excel might be searching for a specified Add-in that it can't
find...........whereas, once it's running ten it doesn't have to look for
it.

Vaya con Dios,
Chuck, CABGx3

 

[dennisfrandsen]

Thanks for the suggestion. That didn't seem to be the issue. I only had
one Add-In set to load on startup (Microsoft Live Meeting) and I took
it out. Still having the same issue.

Thanks anyways...

 

[dennisfrandsen]

Nobody else had this problem, huh?

Thanks for the suggestion. That didn't seem to be the issue. I only had
one Add-In set to load on startup (Microsoft Live Meeting) and I took
it out. Still having the same issue.

Thanks anyways...

 

[CLR]

Do you have anything in the XLStart directory........either a file or
personal.xls that Excel can't find on startup maybe?

hth
Vaya con Dios,
Chuck, CABGx3

 

[Bill Sharpe]

Having a strange issue with Excel 2007. When I open an Excel file
(.xlsx or .xls) by double-clicking the file it takes forever to open
(about 60 seconds). If I have an instance of the Excel application open
already, then double-click the file, it opens right away. The problem
only seems to occur if the application is not already running. The
other weird thing is that when it does take a long time to open, the
application does not appear to be "hung". In other words, when I
double-click on the file, the Excel application opens right away, but I
have to wait for about a minute before the actual worksheet appears. In
the meantime, the application itself seems responsive. I can click on
the menus, etc without any problem.

Anyone else experienced this problem?

Does Excel 2007 open quickly the first time you start it, i.e. without
specifying a particular file to open?

I've got Excel 2007 on a three-year-old laptop with 256 mb RAM and I
sort of expect somewhat slow opening, especially since it's still
officially a beta. But Excel starts in less than 60 seconds.

Bill

 

[dennisfrandsen]

Chuck - where do I find the "XLStart" directory?

Do you have anything in the XLStart directory........either a file or
personal.xls that Excel can't find on startup maybe?

hth
Vaya con Dios,
Chuck, CABGx3

 

[dennisfrandsen]

Here's the behavior I'm seeing:

1. If I open Excel 2007 by itself (without specifying a file), it opens
immediately.

2. If I then use the menu to select a file to open, the file opens
immediately.

3. If Excel 2007 is NOT running already, and I double-click a file to
open it, it takes about a minute to open (even if using the same file
as in step #2 above).

 

[dennisfrandsen]

Chuck - you solved it! I found the XLStart directory and sure enough
there was a file in there ("PDFMaker.xla"). Once I removed it my
problem went away.

Thanks alot!

 

[CLR]

Mine is in
Program Files\Microsoft Office\Office97\Excel

I don't know where it might be in 2007, or if it's even named the
same........but from your description of occurances in your last post, I
don't think this would be the trouble.........don't know what to say about
those conditions............

Vaya con Dios,
Chuck, CABGx3

 

[CLR]

LOL, and after I just posted saying I no longer thought that was the
problem.......go figure.......anyway, glad it's working for you now.........

Vaya con Dios,
Chuck, CABGx3

 

[Guest]

I have exactly the same problem on my tablet Pc.- a lenovo X60 with 2 GB ram.
I also have the same problem/ behavior with word

 

[chang.luo]

I have the same problem because I have created a macro in
personal.xls. After I removed personal.xls, it works fine again.

The MACRO is pretty simple and it works fine on the previous version
of Excel. It basically creates a data list. I am attaching the
macro. This is the first excel macro that I wrote and I am sure I
didn't do everything right. Any thoughts?

--------------
Sub CreateListForLogs()
'
' CreateListForLogs Macro
' Macro recorded 8/21/2006 by Chang Luo
'
' Keyboard Shortcut: Ctrl+q
'
Dim LastColumn As Integer
Dim LastRow As Long
Dim LastCell As Range
If WorksheetFunction.CountA(Cells) > 0 Then



'Search for any entry, by searching backwards by Rows.

LastRow = Cells.Find(What:="*", After:=[A1], _
SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row



'Search for any entry, by searching backwards by Columns.

LastColumn = Cells.Find(What:="*", After:=[A1], _
SearchOrder:=xlByColumns, SearchDirection:=xlPrevious).Column



'MsgBox Cells(LastRow, LastColumn).Address



End If

ActiveSheet.ListObjects.Add(xlSrcRange, Range("A10",
Cells(LastRow, LastColumn)), , xlYes).Name _
= "List1"

ActiveSheet.ListObjects("List1").ShowTotals = True

Range("A11").Select

End Sub

 

[Guest]

Hi all.
Unfortunatly I've tried the same but my problem (huge delay opening excel
files with 2click) still stay there.
Anyone else could help me?
klaus

 

[cathellisuk]

Could this slow opening time have something to do with your Virus
Checker? Sometimes our PC seems to hang when opening a package by
clicking on a file. I think it's our virus checker taking over at
that moment that causes the slow down.

Cath

 

[Guest]

Hi Cath.
I've already tried to close every virus checker without success.
In addition, I have the same behaviuor opening (2click) .doc word files.
Experienced colleagues said this is related to some printer link connected
to files but I didn't find anything.
C

 

[dbouton]

Chuck - you solved it! I found the XLStart directory and sure enough
there was afilein there ("PDFMaker.xla"). Once I removed it my
problem went away.

Thanks alot!






- Show quoted text -

I had the exact problem and removing the pdfmaker.xla file worked for
me also!!! I am glad - it was driving me crazy. I would open the
file and it would just sit. But if I did a minimize it would then
come right up. Now I can open it with no delay at all!

Dawn

 

[Guest]

Unfortunately I've no pdfmaker.xla files on my PC.
So I'm still in a trouble!
Help!
C.

 

[mattborn]

This worked for me and many others:
Here's a link to the forum:
http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=1249654&SiteID=17

Here's the fix:

If this is your problem then you have to add the following to the
file types properties "%1" (also the quotes are necessary)

So open explorer -> Tools -> Folder Options -> File Types

got to the .XL?? extension click Advanced select the bold action ->
Edit and in the box under "Application used..." go to the end and add
the "%1" after the /e

so for the .XLSX Extensions Open command this becomes "<Installation
Folder>\Microsoft Office\Office12\EXCEL.EXE" /e "%1"

When it's the new action it should be "<Installation Folder>
\EXCEL.EXE /e "%1" /n

 

[Guest]

This also solved the problem for me...when I first did it. Now the slow open
seems to have come back. I've checked my settings and the %1 is still there.
Still nothing in the XLSTART folder. I'm tearing my hair out!

Has anyone else who has used the %1 trick found that it stops working?

I sure wish MS would release an update that automatically changes the file
associations to have the %1 in them because it's a pretty time intensive task
to change the dozens of XL* file types.