Solved Excel file won't open

Frank C

Member
I have an Excel file that will not open from Windows Explorer. It will open from Excel's Recent Document List. I want it to open from Explorer because the recent document list changes over time.
The .xlsx file is on a public disk shared by my desktop and a laptop. I did open the file with Open office on the laptop. The laptop does not have Office 2007. Open office may have corrupted the file. It did not change the .xlsx extension. If I can't find a solution I will have to recreate the file from scratch.
Any suggestions?Excel error.jpg
 

My Computer

Frank C

Member
I'm beginning to think my problem is not Excel but Widows Explorer. If I put the path and file name in the file name box and click open, it opens just fine.
C:\Users\Owner\Music\Recordings\Piano\Ohman & Arden\Ohman & Arden.xlsx
Open Box.jpg
 

My Computer

Lottiemansion

Vista Guru
Gold Member
Hi,

The path names are different & therefore they are different file & that is the problem!

Find the one file that works & copy that to a single location & then create two shortcut links to it on both machines.

This will ensure they are both referencing a the same file!

From the information above the file (Ohman & Arden.xlsx) should be in the location above "C:\Users\Owner\Music\Recordings\Piano\Ohman & Arden"
 

My Computer

System One

  • Manufacturer/Model
    HP-Pavilion m9280.uk-a
    CPU
    2.30 gigahertz AMD Phenom 9600 Quad-Core
    Motherboard
    ASUSTek Computer INC. NARRA3 3.02
    Memory
    3582 Megabytes Usable Installed Memory (4 Gig)
    Graphics Card(s)
    ASUS NVIDIA Geforce GTS450
    Sound Card
    Realtek High Definition 7.1 Audio (HP drivers)
    Monitor(s) Displays
    HP w2408 24.0" (Dual monitor)
    Screen Resolution
    1920 * 1200, 1920 * 1200
    Hard Drives
    3*500 Gigabytes Usable Hard Drive Capacity
    Plus 2x USB (160Gig each) external HDD
    BluRay & DVD Weiters
    HL-DT-ST BD-RE GGW-H20L SCSI CdRom (Bluray RW) Device
    AlViDrv BDDVDROM SCSI CdRom (Blueray) Device
    TSSTcorp CDDVDW TS-H653N SCSI CdRom
    Internet Speed
    40 Meg

Frank C

Member
Thanks Lottie,
I deleted all of the .xlsx files except a newly created one here:
"C:\Users\Owner\Music\Recordings\Piano\Ohman & Arden\Ohman & Arden.xlsx
This disk is not shared so I didn't create a shortcut.

The file does not open from Explorer

The file does open if I paste the path/file in the file name box

My explorer has the switch /e,
 

My Computer

Frank C

Member
My problem widens. I tried to access many .xlsx files as well as .docx files via Windows Explorer. I am getting the same error.
I have a few power point files (.PPT) these are OK. I don't have any one note files (.one).
I am going to try a recent restore point
 

My Computer

Barman58

Staff member
Vista Guru
Gold Member
Hello Frank,

The explorer switch /e is just a View option providing a fall back to previous dialogues, it's not the default so could be removed, although I doubt this is your issue.

What you may want to try is check the associations for your .XLSx files, especially as you have, as stated, opened these files in Openoffice

To check


In Explorer, Right Click on the file and you should have an option to "open With ...", [if this option is not visible try shift +Right Click], select this option and check that the option is set to Excel.exe.

If not you should be able to select from a list that includes Excel, [you may need to select the other option if it's not obvious].

There is a checkbox on this tab to "Always open with..." make sure that this is Checked, [unfortunately windows, sets this checkbox to "on" by default and therefore opening a file just once in a different program from your usual one can easily cause this type of issue]
 

My Computers

System One System Two

  • Operating System
    Windows 10 Pro x64 1909 - 18363.488
    Monitor(s) Displays
    Acer G276HL 27", (DVi) + Samsung 39" HDTV (HDMI)
    Screen Resolution
    2 x 1920x1080 @50Hz
  • Manufacturer/Model
    Real World Computers (Custom by Me)
    CPU
    AMD FX8350 Vishera 8 Core @4GHz
    Motherboard
    Asus M5A78L-M USB3
    Memory
    32GB [4x8GB] DDR3 1600 MHz
    Graphics card(s)
    Asus nVidia GTX750TI-OC-2GD5 (2GB DDR5)
    Sound Card
    ASUS Xoner DG + SPDIF to 5.1 System + HDMI
    Monitor(s) Displays
    Samsung 32" TV
    Screen Resolution
    1920 x 1080
    Hard Drives
    Internal
    Crucial CT256MX100SSD1 256GB SSD,
    Seagate ST2000DM001-1CH1 2TB,

    External (USB3)
    Seagate Backup+ Hub BK SCSI Disk 8TB
    2.5/3.5 Hot Swap Cradle, USB3 + eSata (client HDDs)
    NAS 4TB
    PSU
    Aerocool Templarius Imperator 750W 80+ Silver
    Case
    AeroCool X-Warrior Red Devil Tower
    Cooling
    Hyper103 CPU, Rear 120mm, Front 2x120mm, Side 2x120mm
    Internet Speed
    68 MB Down 18.5 MB Up
    Other Info
    Six Sensor Auto / Manual Digital cooling (Fan) control with Touch control Panel

Frank C

Member
Thanks Barman58 ,
Your analysis is correct. Not only did I mess up the connection of the .xlsx that I was working on but I messed up the program connection of ALL .xlsx files. Now, it would seeem simple enough to re-establish that connection. I did not see Excel in the list ("you should be able to select from a list that includes Excel")
Here is my approach:
Settings > Control Panel > Default Programs > Associate a file type or protocol with a program > Select .xlsx > Change

Program > Browse > Open this path; C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Microsoft Office
Select > Microsoft Office Excel 2007
Problem; It doesn't appear in the Other Programs list after I selected it in the list from browse.

Assoc.jpg
 

My Computer

Barman58

Staff member
Vista Guru
Gold Member
OK, from your screenshot it appears that you are selecting the excel entry in the start menu. this is actually just a shortcut

you need to browse to the actual executable file which is EXCEL.EXE

Try at C:\Program Files\Microsoft Office\Office12\

The number shown in the the last folder in the structure would depend on the office version you are using (2007=12, 2010=14, 2013=15 and older than 2007 I seem to remember it was just Microsoft office.

You will of course only need to do this once :)

it's good practice to use the open with, with caution and always check the status of the checkbox,

Perhaps MS will finally set the default to UnChecked in Windows 9 which is the safe option I've seen more than one system where an inadvertent OPEN With change to a system file type are made completely inoperative
 
Last edited:

My Computers

System One System Two

  • Operating System
    Windows 10 Pro x64 1909 - 18363.488
    Monitor(s) Displays
    Acer G276HL 27", (DVi) + Samsung 39" HDTV (HDMI)
    Screen Resolution
    2 x 1920x1080 @50Hz
  • Manufacturer/Model
    Real World Computers (Custom by Me)
    CPU
    AMD FX8350 Vishera 8 Core @4GHz
    Motherboard
    Asus M5A78L-M USB3
    Memory
    32GB [4x8GB] DDR3 1600 MHz
    Graphics card(s)
    Asus nVidia GTX750TI-OC-2GD5 (2GB DDR5)
    Sound Card
    ASUS Xoner DG + SPDIF to 5.1 System + HDMI
    Monitor(s) Displays
    Samsung 32" TV
    Screen Resolution
    1920 x 1080
    Hard Drives
    Internal
    Crucial CT256MX100SSD1 256GB SSD,
    Seagate ST2000DM001-1CH1 2TB,

    External (USB3)
    Seagate Backup+ Hub BK SCSI Disk 8TB
    2.5/3.5 Hot Swap Cradle, USB3 + eSata (client HDDs)
    NAS 4TB
    PSU
    Aerocool Templarius Imperator 750W 80+ Silver
    Case
    AeroCool X-Warrior Red Devil Tower
    Cooling
    Hyper103 CPU, Rear 120mm, Front 2x120mm, Side 2x120mm
    Internet Speed
    68 MB Down 18.5 MB Up
    Other Info
    Six Sensor Auto / Manual Digital cooling (Fan) control with Touch control Panel

Frank C

Member
Remember the eureka moment in "My Fair Lady" when Liza finally said "The Rain in Spain Stays Mainly in the Plain"?
Higgins said " I Think She's Got IT"
That is the way I feel!
Once I got the correct path:
C:\Program Files (x86)\Microsoft Office\Office12\EXCEL.EXE
Now, Open With > Choose default program worked!
All my .xlsx files are opening with Excel.
Thanks Barman58
Frank C.
 

My Computer

Barman58

Staff member
Vista Guru
Gold Member
Glad I could Help :)
 

My Computers

System One System Two

  • Operating System
    Windows 10 Pro x64 1909 - 18363.488
    Monitor(s) Displays
    Acer G276HL 27", (DVi) + Samsung 39" HDTV (HDMI)
    Screen Resolution
    2 x 1920x1080 @50Hz
  • Manufacturer/Model
    Real World Computers (Custom by Me)
    CPU
    AMD FX8350 Vishera 8 Core @4GHz
    Motherboard
    Asus M5A78L-M USB3
    Memory
    32GB [4x8GB] DDR3 1600 MHz
    Graphics card(s)
    Asus nVidia GTX750TI-OC-2GD5 (2GB DDR5)
    Sound Card
    ASUS Xoner DG + SPDIF to 5.1 System + HDMI
    Monitor(s) Displays
    Samsung 32" TV
    Screen Resolution
    1920 x 1080
    Hard Drives
    Internal
    Crucial CT256MX100SSD1 256GB SSD,
    Seagate ST2000DM001-1CH1 2TB,

    External (USB3)
    Seagate Backup+ Hub BK SCSI Disk 8TB
    2.5/3.5 Hot Swap Cradle, USB3 + eSata (client HDDs)
    NAS 4TB
    PSU
    Aerocool Templarius Imperator 750W 80+ Silver
    Case
    AeroCool X-Warrior Red Devil Tower
    Cooling
    Hyper103 CPU, Rear 120mm, Front 2x120mm, Side 2x120mm
    Internet Speed
    68 MB Down 18.5 MB Up
    Other Info
    Six Sensor Auto / Manual Digital cooling (Fan) control with Touch control Panel
Top