A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Hello Denise Webb,
Thank you for posting your question on Microsoft Q&A forum
I understand you can't open your Excel 97 worksheet (.xls file) on your Microsoft Home & Office 2021.
Here is what you can try:
Try using “Open and Repair” feature in Excel
- Open Excel go to File > Open > Browse
- Select the .xls file
- Click the down arrow (▼) on the Open button
- You should be able to see Open and Repair option, choose it.
- Select Repair.
If the file repair proves to be a success and you are able to open the .xls file, you should immediately save as .xlsx to convert them to newer format.
If you still can't open the worksheet, consider using Office online repair too. There is also a possibility that this issue is cause by Excel itself. Please refer to this link for instruction on how to use online repair:
Feel free reply back to this post and update me on the situation, I'll be happy to assist you.