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

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

4. Open Excel.
5. 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

Hi everyone,

It is indeed a rabbit hole Microsoft has us all down these days :) However, I finally got STOCKS working, and I noticed something not mentioned in these threads, that might be of help to others having problems.

First: Let me confirm what ended up working for me, as it has for others in this thread: I installed the older Excel 16.65 and then ran the License Removal Tool. This was essential to get things to work, signing out and in again was not enough.

Second: Here's the thing that may be of interest to others having problems, as there may be two issues muddling things for some people! Because after running the tool and then launching Excel, I saw the dialog in the screenshot below for the first time:

I had never seen this until I ran the License Removal Tool, and here is the key to why the tool was needed. It all has to do with how I (and probably many people) bought Office.

I first bought a license for Office Home & Business 2021 Mac so I could "graduate" from Apple Numbers to Excel, because I assumed Excel would have more advanced stocks and financial tools. Turns out Numbers was actually very close to Excel in this regard, and heaps easier to use, but I digress :)

But, as it turned out, I needed to buy a separate Microsoft 365 subscription to even use the stock-lookups and other tools. I mean, come on Microsoft! Well, whatever — I should have done my homework I suppose :)

But I bet many people will have bought Office Home and Business, thinking you could, oh I don't know, use it for business-stuff like stocks, and then found out they needed an extra subscription, bought that, and then found out it still did not work because of the current bug. So if you're in this situation, download Excel 16.65, run the License Tool, and then choose Microsoft 365 (Recommended) in the dialog seen above.

Because, I am correct that the 365 subscription is still needed, in order to use the Stocks function, right? It's getting confusing and I dare not mess more with it, so if anyone can confirm this is needed, I would be grateful.

Anyways, I hope this helps someone, and may I just say what a wonderful and supportive community I found here! You people are amazingly helpful and friendly. Special shoutout to to Jim Gordon for his incredible level of support here! How you get any other work done, I'll never know, but you're a fantastic ressource to have and I think I can say a huge Thank You from everyone here!

Cheers,

Thomas

Then let me repeat my post, because this is the action you should take:

Hi

It's important for everyone affected to report this misbehavior to Microsoft. The more reports, the more likely someone will notice and add this to the bug database.

Use the Menu Bar and choose Help > Feedback > I Don't Like Something to file a report. Microsoft uses the squeaky wheel method of prioritizing bug fixes. The louder the squeak, the more likely the squeak is to get oil.

And, I will quote eXception handler who offered this verbiage to use in your submission:

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

That's what I left there. Feel free to copy it:

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