Excel Stocks not working in Office 365 after installing macOS Ventura v13.0

tried this, didnt work for me. I appreciate the idea though

hi

its not updating when you hit refresh. and I even went back to 16.65 - which was working previously. I wonder if the Monterey 12.6.3 is the problem suddenly. whereas it wasn't recently?

**Parameters:**Hardware: Mac mini 3.6 GHz Quad-Core Intel Core i3
Software: Office 365 (v16.66.1)
OS: macOS Ventura (v13.0)
Connected Experiences: All On
Auto Update: Have always been On for both Office 365 and macOS

Additional: Nothing new has been installed on the system for over a year (other than SW updates)

TimeLine:

Two days ago: Microsoft Auto Update hung for hours

• Reinstalled MS Auto Update and was able to update MS apps
• Excel Stocks working fine yesterday

This morning: Received error message: "COULDN'T REFRESH DATA TYPES We need to fix your account. Select Microsoft Excel from the top menu > Sign Out. Then sign back in with the account associated with a subscription."

Steps Taken:
Signed out of Office 365; signed back in. No change, and "Stocks" is missing.
Hard Reboot: No change, and "Stocks" is missing.
Scoured the forums online...pretty much tried everything that I could find...

Removed Office 365 Apps, reinstalled, rebooted, etc., signed in again, verified Connected Experiences all are on, and "Stocks" shows up as a menu item: however, when clicking on it, the same error message appears ('COULDN'T REFRESH DATA...").
Removed Office 365 another two times, reinstalled, rebooted, verified Connected Experiences, etc. etc. and no change.
Nothing has changed with my Office 365 subscription (still active, valid, no additional users, etc.).

Thoughts/Questions:

Is this a problem with the latest version of Office 365 (v16.66.1)?

• If so, is there a way to roll back to an earlier version that we know works (I have researched and not been able to find out how to do this.
  Is this a problem with the latest version of macOS (Ventura v13.0)?
• If so, is there a way to roll back to a previous version of macOS?
  If this isn't the right forum to solve this issue, can someone point me to where I can get assistance; I'm happy to pay a fee, as I'm over four hours of spinning my wheels with everything I've tried.

Thanks in advance to anyone who can assist.

Unexpectedly I found a solution.

It has nothing to do with what version of MAC OS you are using. This problem hit me for the first time on 3/24/22. I experienced the usual hours of talking to MS techs, mucking around on their website and reading all the community shared ideas. They led to nothing. I was on an iMac using Monterey 12.6 when the problem kicked in, but I did regularly update the Microsoft 365 apps.

When the stock price error occurred, there was the request to 'sign out' and download a fresh version. That is what sent all of us down the rabbit hole. With the new excel version I noticed the 'stock' data type was mission. So, I tried to re-enter the 'stockhistory' commands manually., "Blocked" showed up. That is when I discovered I had to sign into the new version of MS-365. That requirement was hidden as there was no message to that effect. Where is the sign in option? Also hidden! Go to FILE/NEW FROM TEMPLATE. There, in the upper left corner is the 'sign in' icon. I did it. A message appeared telling me there was an error and they would re-load excel. It was done. Voila, under DATA, the 'stock' data type re-appeared and the 'update all' function worked again.

It is a MS problem. A very embarrassing one.

Thanks. I’ve tried that…it’s one of the things I attempt each time Stocks goes south. I think the missing function is due to signing in and out…not sure if it has trouble synching or just what, but it seems to reappear after a while; sometimes it takes a few hours. IDK