Plan: Available: All plans
Users: Available: All users
Practice Management Source: Available: All sources
Issue
When opening a spreadsheet saved using the FYI Add-in for Microsoft Office, the following error displays:
"This workbook couldn't be opened because the file format may not be matching the file extension."
Cause
This issue occurs when there is a mismatch between the file format and the file extension.
The FYI Add-in saves Excel files using the .xlsx file extension. If Microsoft Excel is configured to save files in a different default format, such as .xlsm, the file contents and extension may not match. This can prevent the file from opening correctly.
If Microsoft Excel is set to save files in a format other than .xlsx, files saved via the FYI Add-in may trigger this error.
Solution
- In Microsoft Excel, click File, then Options.
- Select Save from the left-hand side.
- In the "Save files in this format" drop-down, select Excel Workbook (*.xlsx).
This will resolve the issue for new spreadsheets saved using the FYI Add-in.
For more information, refer to Change the default file format for saving workbooks - Microsoft Support.
If the spreadsheet requires a different format, such as a macro-enabled workbook (.xlsm), saving directly via the FYI Add-in may result in a mismatch.
Solution
- Save the file to a temporary location on your computer.
- Ensure the correct file format (for example, .xlsm) is selected.
- Drag and drop the file into FYI to upload it.
This ensures the file extension matches the file format.
If the error occurs with an existing file that was previously saved, the file may already have a mismatch between its format and extension.
Solution
- Export the file to a temporary location on your computer.
- Open the file in Microsoft Excel.
- Use Save As and select the correct file format.
- Upload the corrected file back into FYI as a new version.
This will ensure the file can be opened and edited correctly in FYI.