A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Hi Amit,
Nice to meet you! My name is Randy and I'm an independent advisor.
If Excel crashes or won’t open certain files on your Mac, You can try this, first reset its preferences by closing Excel, going to ~/Library/Preferences, and moving any com.microsoft.Excel files to the Desktop, then restart Excel; next, clear the Office cache by moving the OfficeFileCache folder from ~/Library/Group Containers/UBF8T346G9.Office/ to the Desktop and try again. For files showing "file version is different," try opening them in Excel Online or saving a new .xlsx copy. If Excel still crashes, fully uninstall Office including apps in Applications and remaining com.microsoft.* files in ~/Library/Preferences and ~/Library/Containers/ then reinstall from your Microsoft account. These steps remove corrupted settings and version conflicts that usually cause crashes and file errors.
When you tried updating Office from the website, did it install over the old version, or did you manually remove the old version first?
Kind regards,