Forum Discussion

Ilaryg_89's avatar
Ilaryg_89
Copper Contributor
May 13, 2020

After creating a macro, I am not able to open the new file saved

Hi ,

al can you please help me?

 

I open an excel, I clicked on "Macro" and saved the new file. I clicked on this and a warning message appeared (notice: I didin't inserted "_" and any spaces in the file name)

"Excel cannot open the file ’20200428Productsb2b.xlsx’ because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file."

 

Thank you a lot,

Ilaria

excel

1 Reply

  • AshaKantaSharma's avatar
    AshaKantaSharma
    Iron Contributor
    May 13, 2020

    Ilaryg_89 You can try below ways:

     

    Workable Solutions Step-by-step Troubleshooting

    Fix 1. Change File ExtensionOpen Microsoft Excel and go to "File" > click Export and choose Change File Type.
    Fix 2. Open in Safe ModePress Windows+R key, type: excel.exe /safe and click "OK" > Save the file as .xlsx...
    Fix 3. Use Open and RepairStart Office Excel > click File and Open > select the inaccessible Excel file...
    Fix 4. Recover from previous versionRight-click the inaccessible Excel document and choose "Properties" > Open the "Previous Version".
    Fix 5. Recover from autorecoverOpen Office Excel and got to "File" tab > Open the file in Excel and click "Restore"

Resources