Excel 2007 - files open slowly

  • Thread starter Thread starter dennisfrandsen
  • Start date Start date
D

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?
 
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
 
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...
 
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...
Click to expand...
 
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
 
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?
Click to expand...
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
 
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
Click to expand...
 
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).
 
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!
 
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
 
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
 
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
 
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
 
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
 
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
 
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
 
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 -
Click to expand...

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
 
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
 
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.
 
Back
Top