Excel Data Types Not Working

Jim G 134K Reputation points MVP
2022-11-13T16:52:41+00:00

Updated 12/19/2022

Data Types are currently not working as expected for all users of Microsoft Excel. The work-around I recommend is to revert to version 16.64.

If you are affected and haven't already done so, please take a moment to notify Microsoft that you are affected by this problem. The way to do it is to use the Menu Bar and choose Help > Feedback > I Don't Like Something. Microsoft uses the Squeaky Wheel method to prioritize bug fixes. The more reports, the higher up the priority list the bug gets. Please do this from the current update of Excel before reverting to 16.64.

To revert to version 16.64:

Use the Menu Bar and choose Help > Check for Updates to launch AutoUpdate

In AutoUpdate, set updates to Manual to prevent AutoUpdate from automatically updating after you revert to the older build.

In Finder, navigate to the Applications folder

Right-click on Microsoft Excel.app and choose Move to Trash

Restart your Mac

Empty the Mac OS Trash

Use this installer to install build 16.64 of Microsoft Excel: Excel

Some users may be able to find a work-around, which is why I am posting this discussion. Some users will be blocked from this due to licensing or IT department restrictions.

There are third-party solutions available. I don't know which ones are great and which ones are less good. I'm hoping people will try them out and reply here with their results and recommendations.

On the Insert tab of the Ribbon choose Add-ins > Get Add-ins.

In the resulting dialog enter the word Stock in the Search field then click the spyglass icon. There are a lot of add-ins available. Let's chat about them in this thread.

Microsoft 365 and Office | Excel | Other | 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

111 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-12-16T19:39:08+00:00

    That's interesting since my non-problem Mac, with Ventura 13.1 and Excel 16.67, has worked fine all along with the Stock data type.

    My other Mac, with Big Sur, is the one with the Stock data type problem for any version of Excel later than 16.64 (even the very latest 16.68 release).

    So much for my theory that it's the version of Mac OS that is the problem.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2022-12-17T20:21:21+00:00

    I've not updated the "good" Ventura-Mac to 16.68, but will soon. I'm guessing it will not break Stocks since this Mac, for some reason, is "immune" to the problem.

    My Office 365 is directly from Microsoft itself.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2022-12-17T17:45:39+00:00

    Have you tried Excel 16.68 on the Ventura Mac?

    Is your app install from office.com or the Mac App Store?

    Was this answer helpful?

    0 comments
  4. Anonymous
    2022-12-14T22:46:20+00:00

    Still annoying the bug exists in Excel when it used to work just fine.

    There are third-party solutions available. I don't know which ones are great and which ones are less good. I'm hoping people will try them out and reply here with their results and recommendations.

    I did try the "Stock Connector" add-in just now. It has price and %-change, but not a spectrum of other metrics like 52-week low/high, dividend info, etc. So this won't work for me.

    Was this answer helpful?

    0 comments
  5. Anonymous
    2022-12-13T03:53:16+00:00

    Thanks, Jim Gordon MVP!

    I tried simply reverting to 16.59, after moving the 16.65 apps to Trash, but that didn't work.

    Only after the Uninstall Office for Mac process, linked above, did I get the Stock data type to work. The key seems to be removing the listed Containers files.

    I may go forward "towards" 16.65, but if the error occurs again, I now know how to revert successfully to a working version.

    Update:

    After finally getting Stocks not to error-out with 16.59 (and after the full Office uninstall, including Microsoft Containers wipe), I decided to try the latest Excel-version 16.67. Result: Fail!! So, I did the full uninstall and reinstall with 16.64. So far, it's fine.

    By the way, the problematic Mac is running Big Sur. I have a newer Mac running Ventura and I've not had a problem with 16.67

    Was this answer helpful?

    0 comments