14 September 2017

Solution for Excel opening blank when you double-click a file icon or file name

Problem with running the latest Excel, where i cannot open Excel files when double-clicking the files, but i can drag the files and they open.

Microsoft Support stats the following but non of the proposed solutions resolved the issue.
https://support.microsoft.com/en-us/help/2994633/excel-how-to-troubleshoot-excel-opening-blank-when-you-double-click-a

You can solve it the hard way by just sending the filepath as a command line parameter to Excel!

Create a Excel.cmd file and locate in e.g. c:\program files with the following content

Excel.cmd
start "Opening files with Excel fix" "C:\Program Files (x86)\Microsoft Office\Root\Office16\EXCEL.EXE" %1

Then right click the xlsx file and open with, mark always, and choose another program and find your Excel.cmd file. Using start means the command window closes after excel opens, without start the cmd file is open in the background.

This is the most basic way of sending files to programs and it works for excel too :) 

No comments: