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-12T02:17:52+00:00

    Two Questions for Everyone concerning Ventura update v13.0.1:

    First Question: I realize most of us have rolled back to Excel 16.65, but does anyone know if updating to Ventura 13.0.1 allows our Excel 16.65 to continue to work?

    Second Question: Does Ventura 13.0.1 work with the current version of Excel v16.66?

    I'm way too hesitant to update either, as it took me a week to get out of the original mess--I'm hoping someone might be able to answer the question who doesn't rely on Excel stocks perhaps.

    Thanks in advance.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2022-11-11T22:48:20+00:00

    Thank you!!!

    I had done all steps but I was not aware of step 5 (the ribbon and toolbar reset)!

    I might have missed it when I was going through the old replies.

    That fixed the issue with #VALUE!

    Everything is working now :)))

    Thanks again!

    Was this answer helpful?

    0 comments
  3. Anonymous
    2022-11-11T22:10:17+00:00

    OK. your first formula was wrong because it did not have the requirement for what you want displayed after the date part. Those let you select periods (day or week etc.), whether you want a header and then what prices you want such as close prices and volume.

    I do understand your issue since I worked through it with Microsoft support and had all the initial issues with it that happened after support chats. In the end, I got it all running.

    Yes, I use Ventura and yes I use 16.65.

    Here are the steps I used and wrote earlier in the thread that were successful. Several others utilized this procedure and they were successful. The first chat helps with Microsoft did not have you turn off office updates first which is critical. The first time I had it the problem was solved but the next day it did not work. What happened? Autoupdate did its job and converted it back to Excel 16.66.1.

    One critical question (and the problem happened to me using 16.65) is when you start typing the formula, =STOCKHISTORY does the suggested rest of the formula help appear describing your choices or options as you fill in the formula? If not, one of a couple of things is happening. The first is that the copy of 16.65 is corrupted probably because you did not do the steps exactly as written or not all of them. Installing 16.65 is not enough, you have to reset the customizations. The second thing is that STOCKHISTORY only is offered in Excel 365. If you are using any version but 365 the dynamic array functions which STOCKHISTORY is are not offered.

    1. Turn off auto-updates in office.
    2. Move the Excel file from Applications to Trash.
    3. Download and install 16.65 with this link.

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

    1. Open Excel.
    2. Go to Preferences - Ribbon and Toolbar and at bottom you see three dots in a circle. Click on that and choose reset all customizations.

    Following this exactly as shown should help you...... let me know.

    Good Luck

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  4. Anonymous
    2022-11-11T21:30:32+00:00

    I appreciate you trying to help out but you are misunderstanding the problem.

    The issue is not that the formula is not correct, but that it does not work anymore after upgrading to Mac OS Ventura.

    I also have an excel spreadsheet with tons of SOCKHISTORY() formulas and tables. Everything worked like a charm under Mac OS Monterey, but now all those formulas are getting flagged with #VALUE! and are broken.

    Same happens with the formula that you shared as you can see from the picture.

    So, my question to you is: what OS and Excel version are you using? Are you using Mac OS Ventura and Excel 16.65?

    Was this answer helpful?

    0 comments