After Ambiguous Error - Can't Open

Start Excel in safe mode
Safe mode lets you start Excel without encountering certain startup programs. You can open Excel in safe mode by pressing and holding Ctrl while you start the program, or by using the /safe switch (excel.exe /safe) when you start the program from the command line. When you run Excel in safe mode, it bypasses functionality and settings such as alternative startup location, changed toolbars, the xlstart folder, and Excel add-ins. However, COM add-ins are excluded.

If your issue is resolved after you run Excel in safe mode, see: https://support.microsoft.com/en-us/...rs=en-us&ad=us.

SOURCE : https://support.microsoft.com/en-us/...ommand%20line.


if this helps please consider clicking "add reputation" ... thx

You could try opening the file in LibreOffice Calc.

Download LibreOffice for free and install it. https://www.libreoffice.org/download...d-libreoffice/

I usually save a lot but I was testing some weird code and boom it happened. I have backups but I had written a few macros I hate to have to redo lol.

Safe mode didn't work it just hangs on the splash screen.

I will try LibreOffice

Edit:
I was able to open in in LibreOffice however it dropped off all my Connections and Data Model
I was able to export all my macros though from Libre and now I just have a few things to redo in the Excel file and can just import my code in. Phew.

Thanks all.

One step at a time . . .

Ahhh, several steps achieved

Thanks for the rep.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.