Microsoft excel 2007-not opening excel files

Asked By 20 points N/A Posted on -
qa-featured

Hello,

I am having some problem with ms excel installed in my PC. I used it even yesterday.

But now it is not opening the excel files. However the other office components are working properly.

Under the circumstances I do not know what to do.

Please someone help me get rid of these of this problem.

Evin Gizmo

SHARE
Answered By 0 points N/A #195211

Microsoft excel 2007-not opening excel files

qa-featured

There are few ways of solve this problem. All of them are given below:

1. It can be a possible issue withPersonal.xlsb – the file where your personal macros are stored. Navigate to here and delete the file (if there is a file)
C:Documents and SettingsUSERIDApplication DataMicrosoftExcelXLSTART
Excel will create a new file if you record a macro.

2. Office button, Excel options, Advanced tab, general section: 

make sure "Ignore other applications that use DDE" is unchecked . this process should work.

3. There's another permanent solution for this problem

In Windows Explorer go to:
Tools>Folder Options>File Types

Then scroll down to XLSX and click Advanced.
Under Optionsdouble-click/Edit OPEN

Change the line under "Applications to Perform action" from

"C:Program FilesMicrosoft OfficeOffice12EXCEL.EXE" /e

to

"C:Program FilesMicrosoft OfficeOffice12EXCEL.EXE" /e "%1"

Also DDE Message should be:
[open("%1")]

That fixes the issue permanently.

Related Questions