How to Use Macros in Excel. This wikiHow teaches you how to enable, create, run, and save macros in Microsoft Excel. Change the file format to XLSM. Click the 'Save as type' drop-down box. Click a folder in which you want to save the Excel file (e.g., Desktop). On a Mac, you must first click the 'Where' drop-down box.

Excel Cannot Open the File/the File Format or File Extinction Is Not Valid Sometimes, when you are editing an Excel file on Microsoft Office 2007, 2010, 2013 or 2016, it suddenly refuses to open and shows the following error: 'Excel cannot open the file 'filename.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. (OK)' It usually indicates corruptions or an incorrect file format on the file. Next, we will give our advice on how to fix the problem. PAGE CONTENT: Quick fixes Advanced solutions Worthy tips(protect Excel file securely) Quick Fixes to 'Excel Cannot Open the File.xlsx' Error on Office Fix 1. Change the Excel File Extension Step 1.

Open Microsoft Excel and go the File tab. Step 2. Click Export and choose Change File Type.

Click on Erase. Wd my book formatted for mac need to read on windows 7.

Change the file extension to.xlsx. Check if Excel can open your file or not. Open the Excel File in Safe Mode Step 1. Press Windows+R key, type: excel.exe /safe and click OK. Save the file as.xlsx.

It sometimes helps to access your data if Excel cannot open the file.xlsx because of the file corruption. Advanced solutions to 'Excel Cannot Open the File.xlsx' Error on Office If the problem still exists, even after you have tried all the quick fixes we mentioned above, here, we also offer two advanced solutions to eventually remove this error. Open Excel File Using Open and Repair Feature Step 1. Start Office Excel.

On the File menu or the Microsoft Office button, click Open. In the Open dialog box, click to select the inaccessible Excel file. Step 4. Click the down arrow on the Open button, and then click Open and Repair. Microsoft Office will then start to check the Excel document and repair any problems or corruptions it found.

Recover Excel File from the Previous Version Method 1 Note: This method can only restore lost files to a previous version. It means that you may lose some changes you may have made to the document. Right-click the inaccessible Excel document and choose 'Properties'. Open the 'Previous Version' tab to list all the previously stored version of the Excel file. Choose the right version and click 'Restore' to retrieve the document. Method 2 Note: This method only works when you have turned on the AutoSave feature in Office Excel.

Open Office Excel and got to File tab > Click Info. Beside Manage Versions, you'll see all autosaved versions of your file. Open the file in Excel and click Restore. Save the file with another file name and set the extension as.xlsx. Worthy Tips Method 1. Recover Deleted or Lost Excel File with Free Recovery Software Besides 'Excel cannot open this file' error, accidentally deleting Excel file is the most common issue that may occur to any one of you ordinary Excel users.

If you find no Excel autosaved files, no previous version when you lost an Excel by deletion, EaseUS is worth to try. It allows you to within just 3 simple step.