issues with refreshing "Data Types" in Excel 365, says "We need to fix your account", Sign in and out.

Anonymous
2022-11-04T07:49:20+00:00

Hi,

since a few days I have issues with Excel 365. Above the grid it mentions "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 an account associated with a subscription." I have followed the instructions by signing out and then in again however it didn't resolve the issue and it repeats. I have been using Office 365 for many years and just recently the problem started. Now I can't refresh the data. I have checked my subscription and there seems nothing wrong with it and is all updated. Kindly assist me with this issue.

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

59 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-12-12T01:33:38+00:00

    hi, I can confirm I managed to have STOCKS continue to work after restarting Excel following a downgrade to 16.64. Let's see how long this workaround will work.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2022-12-08T19:11:36+00:00

    It only worked for about 15 minutes then stopped again.

    I have a PC / win 11/ office 365. Reverted to: Version 2210 (Build 15726.20202)

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2022-12-03T12:20:42+00:00

    Hi all,

    I managed to narrow down steps to solve this issue until you quit Excel and reopen... but I cannot imagine doing this every time I reopen Excel - this is a ridiculous bug that has been causing issues for more than a month and Microsoft does absolutely nothing to fix it!!

    Steps below:

    1. Sign out of Excel
    2. Uninstall Excel
    3. Clear the following folders:
      1. ~/Library/Containers/com.microsoft.Excel/Data/Library/Caches/
      2. ~/Library/Containers/com.microsoft.Excel/Data/Library/Application Support/Microsoft/Office/16.0/Wef/
    4. remove the following folders from your Mac under ~/Library/GroupContainers
      1. UBF8T346G9.ms
      2. UBF8T346G9.Office
      3. UBF8T346G9.OfficeOsfWebHost
    5. Download Excel and Sign in, Activate Licence

    Once you restart Excel, it signs you out and downloads some privacy settings that are causing the issue.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  4. Jim G 134.1K Reputation points MVP
    2022-12-02T22:31:47+00:00

    Yes, and you can use an old build of Excel as described here:

    Data Types are not working.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  5. Anonymous
    2022-12-02T21:17:49+00:00

    My MacBook Air has this issue. But, the issue goes away if I use the web version Excel.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments