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 No comments

59 answers

Sort by: Most helpful
  1. Anonymous
    2023-01-27T09:41:48+00:00

    Good news: they fixed it. Just relaunch Excel.

    Can Microsoft please improve its hopefully automated QA workflows to include testing for this behaviour in Excel for Mac?

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2023-01-12T18:07:42+00:00

    Thank you for this, I appreciate the reply. It's amazing how MS can just take their sweet time on such obvious problems.

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2023-01-11T19:40:35+00:00

    MacOS 13.1 on M1.

    Excel version 16.69.

    This problem has been around for several versions of Excel. When is MS going to wake up and do something about this? I have to switch to Apple's Numbers for the interim.

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2023-01-11T19:20:23+00:00

    Excel 16.69

    The problem is there ... I now have two Stocks, both don't work.. I have already reset excel preferences, both manually by removing all excel prefs files and through the App's Preferences.

    Image

    Was this answer helpful?

    0 comments No comments
  5. Anonymous
    2023-01-11T12:10:22+00:00

    Good Morning

    I see that MS has released a new version of MS Office including Excel

    January 10, 2023

    Version 16.69 (23010700)

    Wonder if anyone has tried it and if in excel the Data type refresh (stocks)

    has been fixed and works ?

    Thanks

    Was this answer helpful?

    0 comments No comments