Excel 2007 opens blank document

Normal
0

false
false
false

EN-US
X-NONE
X-NONE

MicrosoftInternetExplorer4

/* Style Definitions */
table.MsoNormalTable
{mso-style-name:”Table Normal”;
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-qformat:yes;
mso-style-parent:””;
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin:0in;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.0pt;
font-family:”Arial”,”sans-serif”;
mso-bidi-font-family:”Times New Roman”;}

Problem:

Excel 2007 opens the program but not the document when double-clicking excel files from Windows Explorer.

Solutions:

–       Office button, Excel options, Advanced tab, general section:
make sure "Ignore other applications that use DDE" is unchecked.

–       Click on document
When app opens, click ‘file open’
navigate to document and click (still nothing in Excel window)
Go to View tab
Click unhide and select spreadsheet.

–       From what I can find, it may be a possible issue with Personal.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.

–       Go to your Control Panel, (click on Start then Click on Control Panel)
Click on Folder Options, then File Types,
scroll down to and select (DOC for Word files) or XLS (for Excel files),
click Advanced and select Open entry,
click the edit Button.
deselect "Use DDE"
append "%1" (include the quote marks) to the end of the application command line,
Remove /dde if it is at the end of the command line
Then click on OK three times.

–       Open up your Excel 2007 document. Likely it will open blank.
Click View
Click Arrange All
Click the Tiles Option
Click OK and your Excel document should now show data and not be blank.
Click Save to save the document or else it will open blank again.