Excel 2007 opening files slow & errors

[Jalal]

I have installed XL 2007 and it was O.K to open files by double clicking on
the file icons on the Desktop but the problem it was taking around 60 seconds
to open. I was searching for a solution for the slow opening files from the
Desktop and I found relative discussion and the advice was to go to the
Control Panel under Folder Options and then File Type Tab and to change
something relates to DDE but after I exit I faced problem in opening Excel
2007 from the Desktop with the below Error Message.

'D:\Documents.xls' could not be found. Check the spelling of the file name,
and verify that file location is correct.

If you are trying to open the file from your most recently used files, make
sure that file has not been renamed, moved, or deleted.

And the above message repeating with the different file name that is not the
same file that I clicked on. What I noticed is that the above message is
reflecting the file that I want to open by each word separately and after I
click on OK the file open.

I feel that something has been changed in the File Type.

 

[Nick Hodge]

Jalal

That looks like the older issue of un-checking 'ignore other applications'
(It is basically stalling on the spaces in the filename. If you keep
answering yes or ok you will see it progresses through the file name)

Go to Office Button>Excel Options>Advanced>General>Ignore other applications
that use DDE (Uncheck it)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.excelusergroup.org
web: www.nickhodge.co.uk

 

[Jalal]

Thanks Nick,

When I went to the Excel Options, I found that the Box is un-checked and
when I checked it, I had the same message but the file does't open.

So, if the Box unchecked you will have the message but if you keep clicking
on OK the file will be opened.

FYI, the 2003 files opening without this message, also if the Excel
Application open this message not apearing.

 

[Nick Hodge]

Jalal

The next option is to try re-registering the file associations in Excel. To
do this go to start>run in windows and in the dialog type

excel.exe /regserver

Make sure there is a space before the slash and make sure Excel is shut when
you do this

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.excelusergroup.org
web: www.nickhodge.co.uk

 

[Jalal]

Nick,

Still have the same message. What about if I reinstall Excel 2007?

 

[Nick Hodge]

You can try a re-install over the top

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.excelusergroup.org
web: www.nickhodge.co.uk

 

[Jalal]

Could you please clarify the meaning of (re-install over the top).

 

[Nick Hodge]

Jalal

Just insert the DVD and select the repair option that pops up. It will not
remove Office/Excel, but will re-install 'over the top' of the old
installation repairing any corrupt files or associations.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.excelusergroup.org
web: www.nickhodge.co.uk

 

[kevster4u]

I had the same problems with Excel either opening XLS and XLSX files
slowly or not at all. I just fixed the file associations for both of
them. Here is what I did.

1) Open an Explorer window and click Folder Option, then File Types.
Scoll down to either XLS or XLSX file type (you need to do the same
for both of them)

2) Once you has XLS (or XLSX) selected, then click Advanced.

3) Click on the OPEN action and then click Edit.

4) Under the Application to use box it probably says "....Microsoft
Office\Office12\EXCEL.EXE" /e" or something similar. Replace the /e
with "%1" (including the quotes). so it should now look like this:

"...Microsoft Office\Office12\EXCEL.EXE" "%1"

5) You can uncheck the "Use DDE" also.

Once that is done close out of all those screen and try to open the
XLS (or XLSX depending on what which one you changed) and it would
open right up in Excel. This fixed the problems I was having.

 

[fyz]

Hi,

I think your excel file may be corrupt. And you may try a popular
Excel file recovery tool called Advanced Excel Repair to repair your
Excel file. It is a powerful tool to repair corrupt or damaged Excel
files.

Detailed information about Advanced Excel Repair can be found at
http://www.datanumen.com/aer/

And you can also download a free demo version at http://www.datanumen.com/aer/aer.exe

Alan

 

[hobo_joe]

You're a bloody Legend mate!!!

It's been bothering me for ages and you are the only person who knew my
problem. I knew there had to be a way to alter the way windows looks at
files!! Thanks heaps from Australia

 

[c-nam]

When I typed excel /regserver Excel started to open and then immediately
crashed.

 

[Paty]

Thanks God someone had the answer. I worked pretty fine for me with Excel
2007 and Windows XP. Greetings from Mexico

 

[babunahas]

man!!!!! u saved my time searching here and there for a help on this problem.
hats off to u!!!!! thanks once again.....

 

[tcarmen94]

Where is 'folder options' on the explorer window? I see 'internet option' but
that's it. Thanks.