M
Mike T
For me the culprit was a print application in C:\Program Files\Microsoft Office\OFFICE11\XLSTART.
When I removed it, Excel files started opening properly.
The same application appeared in C:\Program Files\Microsoft Office\OFFICE11\STARTUP so I removed it from there as well.
THE application was a print program (p-touch label printer)and it appeared on all my toolbars (or apparently tried to). Perhaps the change to the ribbon from the old button bar interface created a conflict.
What a relief to have this fixed!
dennisfrandse wrote:
Re: Excel 2007 - files open slowly
29-Dec-06
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).
Bill Sharpe wrote:
Previous Posts In This Thread:
Excel 2007 - files open slowly
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'tfind...........
Excel might be searching for a specified Add-in that it cannot
find...........whereas, once it is running ten it does not have to look for
it.
Vaya con Dios,
Chuck, CABGx3
Thanks for the suggestion. That didn't seem to be the issue.
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 wrote:
Re: Excel 2007 - files open slowly
Nobody else had this problem, huh?
Do you have anything in the XLStart directory........either a file orpersonal.
Do you have anything in the XLStart directory........either a file or
personal.xls that Excel cannot find on startup maybe?
hth
Vaya con Dios,
Chuck, CABGx3
for
Re: Excel 2007 - files open slowly
(e-mail address removed) wrote:
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
Re: Excel 2007 - files open slowly
Chuck - where do I find the "XLStart" directory?
CLR wrote:
Re: Excel 2007 - files open slowly
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).
Bill Sharpe wrote:
Chuck - you solved it!
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 wrote:
Mine is inProgram Files\Microsoft Office\Office97\ExcelI don't know where it
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
had
took
look
LOL, and after I just posted saying I no longer thought that was theproblem....
LOL, and after I just posted saying I no longer thought that was the
problem.......go figure.......anyway, glad it is working for you now.........
Vaya con Dios,
Chuck, CABGx3
had
took
look
I have exactly the same problem on my tablet Pc.- a lenovo X60 with 2 GB ram.
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.
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
On Jan 29, 12:18 pm, Richard GustaVsson <Richard
(e-mail address removed)> wrote:
Hi all.
Hi all.
Unfortunatly I have 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 VirusChecker?
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.
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
:
Re: Excel 2007 - files open slowly
On Dec 29 2006, 11:58 am, (e-mail address removed) wrote:
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
Unfortunately I've no pdfmaker.xla files on my PC.So I'm still in a trouble!
Unfortunately I have no pdfmaker.xla files on my PC.
So I am still in a trouble!
Help!
C.
Re: Excel 2007 - files open slowly
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.
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.
:
EggHeadCafe - Software Developer Portal of Choice
Dynamic ASP.NET Excel Workbooks In C#
http://www.eggheadcafe.com/tutorial...0d-94301c5edc4d/dynamic-aspnet-excel-wor.aspx
When I removed it, Excel files started opening properly.
The same application appeared in C:\Program Files\Microsoft Office\OFFICE11\STARTUP so I removed it from there as well.
THE application was a print program (p-touch label printer)and it appeared on all my toolbars (or apparently tried to). Perhaps the change to the ribbon from the old button bar interface created a conflict.
What a relief to have this fixed!
dennisfrandse wrote:
Re: Excel 2007 - files open slowly
29-Dec-06
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).
Bill Sharpe wrote:
Previous Posts In This Thread:
Excel 2007 - files open slowly
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'tfind...........
Excel might be searching for a specified Add-in that it cannot
find...........whereas, once it is running ten it does not have to look for
it.
Vaya con Dios,
Chuck, CABGx3
Thanks for the suggestion. That didn't seem to be the issue.
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 wrote:
Re: Excel 2007 - files open slowly
Nobody else had this problem, huh?
Do you have anything in the XLStart directory........either a file orpersonal.
Do you have anything in the XLStart directory........either a file or
personal.xls that Excel cannot find on startup maybe?
hth
Vaya con Dios,
Chuck, CABGx3
for
Re: Excel 2007 - files open slowly
(e-mail address removed) wrote:
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
Re: Excel 2007 - files open slowly
Chuck - where do I find the "XLStart" directory?
CLR wrote:
Re: Excel 2007 - files open slowly
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).
Bill Sharpe wrote:
Chuck - you solved it!
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 wrote:
Mine is inProgram Files\Microsoft Office\Office97\ExcelI don't know where it
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
had
took
look
LOL, and after I just posted saying I no longer thought that was theproblem....
LOL, and after I just posted saying I no longer thought that was the
problem.......go figure.......anyway, glad it is working for you now.........
Vaya con Dios,
Chuck, CABGx3
had
took
look
I have exactly the same problem on my tablet Pc.- a lenovo X60 with 2 GB ram.
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.
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
On Jan 29, 12:18 pm, Richard GustaVsson <Richard
(e-mail address removed)> wrote:
Hi all.
Hi all.
Unfortunatly I have 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 VirusChecker?
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.
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
:
Re: Excel 2007 - files open slowly
On Dec 29 2006, 11:58 am, (e-mail address removed) wrote:
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
Unfortunately I've no pdfmaker.xla files on my PC.So I'm still in a trouble!
Unfortunately I have no pdfmaker.xla files on my PC.
So I am still in a trouble!
Help!
C.
Re: Excel 2007 - files open slowly
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.
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.
:
EggHeadCafe - Software Developer Portal of Choice
Dynamic ASP.NET Excel Workbooks In C#
http://www.eggheadcafe.com/tutorial...0d-94301c5edc4d/dynamic-aspnet-excel-wor.aspx