A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Solution: I had not activated my Home office account yet.
For some reason Excel would allow me to open new and old documents but never save. When I tried to save it would say I needed to activate my account. It did not give me a link or tell me how to do this. So I decided to try word to see if it had the same problem. When I opened word there was an error message just below the menu bar in yellow saying I needed to activate the account. I followed the link and boom. Word would allow me to save. Then I opened Excel and it allowed me to save.
I am still curious as to why this situation ever arose. My 2021 Mac version of office was working just fine until one day it stopped allowing me to save. I upgraded to Home office 2024 for Mac and the problem persisted until I activated it. How my 2021 version of Excel became deactivated, I will never know