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
    2023-01-23T04:05:09+00:00

    Yup.. Microsoft has gone to the way Microsoft used to be... I am calling Microsoft and asking them to refund me for every month this bug has been festering on this pile of ineptitude and indifference.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2023-01-23T01:19:44+00:00

    Just wasted 2 hours until I found this thread. Can't believe MS HASN'T FIXED THIS!

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  3. Jim G 134.1K Reputation points MVP
    2023-01-12T17:57:40+00:00

    The work-around is to install version 16.64 until Microsoft fixes this issue. Instructions are here:

    Data Types are not working.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  4. Anonymous
    2023-01-01T19:19:16+00:00

    Hi all,

    I've isolated the root cause and the issue is with the MicrosoftRegistrationDB_*.reg file. Deleting the MicrosoftRegistrationDB folder or its content after quitting Excel will work - no need to login:

    **~/Library/GroupContainers/**UBF8T346G9.Office/MicrosoftRegistrationDB

    Hope this helps and it's pity Microsoft isn't willing to fix this bug.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  5. Anonymous
    2022-12-19T20:13:46+00:00

    I also managed to fix the problem. What I did was to change my password for my outlook.com email address.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments