Like OS version, Office Version, whether there is special data in the sheet, etc. If you can repro the issue in your Mac with a new file, feel free to let us know more details Meanwhile, we created a new workbook in our end to test and the added sheet displays when we open it in Mac.
(Note: Since Microsoft can't retrieve the file saved locally, we kindly suggest you save your files in cloud to protect your files (e.g. If the added sheet displayed normally there, please try saving a copy and downloading it in your Mac to see the outcome. Is there a copy in your PC or whether you uploaded it in your personal OneDrive or OneDrive for Business? If so, please open it there to check whether you saved that workbook successfully after youĪdded the sheet.
