Microsoft excel 2007-not opening excel files

Asked By Evin Gizmo 20 points N/A Posted on - 03/12/2012

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

• Status: Open
• Question Views: 1057
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Oleksii bagsic 0 points N/A #195211

Microsoft excel 2007-not opening excel files

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.

About Oleksii bagsic

Questions
0

Answers
27

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 03/12/2012
• Question Category: MS Excel