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

Anonymous
2022-10-25T17:56:07+00:00

**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.

Microsoft 365 and Office | Excel | For home | MacOS

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
Anonymous
2023-01-26T18:59:10+00:00

I just received this from Microsoft:

Thank you for sending Microsoft feedback. Your input is valuable to us and helps improve our products.

Your feedback directly resulted in improvements to Office and we believe your issue has been addressed in the latest version of Office 365. Thank you! To get the latest update, follow the steps here.

For your reference, you submitted the following feedback on November 3, 2022:  MacOS Ventura 13.0 users have to downgrade to Version 16.65 because all newer versions up to beta 16.68 do not support stock quotes anymore! See this community report: https://answers.microsoft.com/en-us/msoffice/forum/all/excel-stocks-not-working-in-office-365-after/392964ae-24de-43c2-af1e-07aa33659a61

If you have any questions, please reply back to this email. 

Thank you,
The Microsoft Office Team

Note: Bold & Underline above was added by me

Was this answer helpful?

4 people found this answer helpful.
0 comments

135 additional answers

Sort by: Newest
Most helpful Newest Oldest
  1. Anonymous
    2022-11-01T22:00:30+00:00

    That’s disappointing. Sorry.

    I’ll tell Microsoft now.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2022-11-01T21:32:08+00:00

    Didn't work.

    I followed the instructions but suddenly all of the functions that have anything to do with stocks, like STOCKS and STOCKHISTORY are missing. When you type them in all you get is a #NAME! error.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2022-11-01T21:03:59+00:00

    Here’s what Microsoft has suggested to me (which they say is a workaround). I can’t verify for the next few days, as I’m out-of-town. Note: Proceed at your own risk, as I’ve not tried this (I have, repeatedly, deleted Office 365 and reinstalled it, turned off updates, signed out and in, etc etc, and that did not work for me).

    If someone does try this, it would be nice to let everyone know if it works.

    Thanks in advance!

    ————————

    FROM MS:

    However, at the time there is a walkaround for this. Kindly follow these steps 

    Sign out of your account on all office applications

     Move Excel only to trash 

    Unpin it from the Dock if pinned 

    Download this excel build https://officecdn.microsoft.com/pr/C1297A47-86C4-4C1F-97FA-950631F94777/MacAutoupdate/Microsoft\_Excel\_16.65.22091101\_Updater.pkg 

    Install and then open app

    Do not activate the product just yet 

    Click on Help at the top and select "Check for Updates"

    Do not update  please Uncheck "Automatically Check for Updates"

    Close that windows and return Excel home screen 

    Select Excel at the top 

    Click on Activate 

    Sign in 

    Click on stock to load 

    Kindly keep update unchecked while we work on pushing out the next update where issue is not present

    Was this answer helpful?

    0 comments
  4. Anonymous
    2022-11-01T20:25:52+00:00

    Jim,

    I am not sure the Time Machine backup works. My issues started when I upgraded to Ventura, I believe last Thursday night. Friday is when I started having problems and discovered the Excel 16.66.1 October 28 version. I just checked my backup in Time Machine and it appears that my oldest backups are October 28th first thing in the morning. I still have 47g free on the drive so I think, but don't know for sure, that upgrading to Ventura erased all the old backups and started as if Time Machine was brand new upon OSX Ventura upgrade.

    I may have to try the other tack of trashing Excel and installing the last build. I don't use Outlook so no issue there.

    Was this answer helpful?

    0 comments