Excel 2016 for Mac when launched it says open last saved file or cancel, then it opens the new file.

My issue got fixed using the below procedure thanks for Richard.

Regards,

Prashanth

Please try make sure you have data back.

If you want to try something that has worked for me and someone else I'll share this with you. Just please understand that all of your preferences for Word, Excel, PowerPoint and Outlook will be removed and you will have to reset them.

Before starting the process you must quit all Office applications, including Outlook, Excel, Word and PowerPoint... and remember "closing" is not "quitting" on a Mac. If you are unsure about whether an Office application is still running it would be best if you restarted your computer. You will also need to know your sign in ID for your Microsoft Office account if you obtained it via an Office365 subscription.

When you are ready, go to this location and move to the trash the MicrosoftRegistrationDB.reg file that is located there. This is a locked file so you will need to confirm your request to delete it.

/Users/<your  home directory name>/Library/Group Containers/UBF8T346G9.Office

Now restart Word and when it opens it will display the document gallery page and you will notice that you are not signed in. You should go ahead and do that with your Microsoft Office sign-in ID.

Your recent list will probably be empty but go ahead and start a new document and save it. Quit Word and reopen it and then check the Recent List. Hopefully it will have repopulated with at least some of your previous files and also hopefully it will continue to do so.

Please let us know if this helps.

________________________________
Richard V. Michaels
info@greatcirclelearning.com
Author of productivity add-ins for Mac-Office and Win-Office.