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-17T20:31:13+00:00

    This "unable to refresh data types" was causing me all kinds of trouble. Not a problem on my Windows tower but sure didn't work on my Mac laptop. I talked to Microsoft support a week or so ago but they weren't able to fix the problem. Followed the instructions here to uninstall and reinstall 16.64 and it was fixed in half an hour.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  2. Anonymous
    2022-12-16T18:46:09+00:00

    On M1 MacBook Ventura 13.1

    Removed all Office applications (except for OneDrive), removed all ~/Library/Containers Office folders (again except for OneDrive).

    Reinstalled from Mac AppStore MS Excel version 16.68.

    Issue remains with Stock Data with the same suggestion to log out and log back in with Office 365 subscription which I have.

    Additional info:

    I had support call with Microsoft and did similar steps (except for the ~/Library/Containers ones) and installing Office from office.com. Exact same results.

    I showed the agent thru a Chrome browser session screen share all the steps and issues.

    I also showed that I can open the same example MS Excel file using onedrive online / over the web and demonstrate that the Stock Data connector works with the cloud version but not the desktop version for the same subscription account.

    The call was then dropped and I got no more support from Microsoft. Seems that the support agent was lost on next steps and opted to just end the call.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  3. Anonymous
    2022-12-11T14:24:03+00:00

    Thanks for this Jim, in a bizarre way I’m (not so) happy to see it is not just me and a recognised issue reflected in the community.

    I’ll do as you suggest and send the feedback directly to MS.

    On a secondary note, I’ve already been down the ‘add-in’ route and applied an alternative which isn’t as detailed, simple to apply or convenient but at least I’m able to update the sheet with ‘some’ live (delayed) data.

    Thank you very much for your time. It IS appreciated.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  4. Anonymous
    2022-12-16T17:56:42+00:00

    How do you do a "Microsoft Containers wipe"?

    Please ignore! I found it

    Remove Microsoft files in ~/Library/Containers

    This link has the details: https://nektony.com/how-to/uninstall-office-365-mac

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  5. Anonymous
    2022-12-13T02:10:48+00:00

    My thanks as well. Stock prices started erroring for me last week. I found lots of suggestions that didn't help but falling back to 16.64 did the trick. And of course, I have auto update turned off for now so will keep checking here for you to say we should be OK to update once again.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments