Forum Discussion

PREET's avatar
PREET
Copper Contributor
Feb 10, 2025

"OVERWRITE EXISTING CELLS WITH NEW DATA..." GET DESELECTED

HELLO , I HAVE OFFICE 365 . FROM 1 MONTH AGO THE BUTTON IN DATA TAB THEN PROPERTIES AND IN IT "OVERWRITE EXISTING CELLS WITH NEW DATA..." GET DESELCTED AUTOMATICALLY AND WHEN WE REFRESH DATA IT GET ...
admin
BI & Data Analysis
developer
excel
office 365
power bi
Kidd_Ip's avatar
Kidd_Ip
MVP
Feb 10, 2025

May consider below before contacting Microsoft support:

 

  • Update Office 365: Ensure your Office 365 application is up to date. Sometimes bugs are fixed in newer updates.
  • Check for Add-ins: Disable any add-ins that might be interfering with Excel's functionality. Go to File > Options > Add-ins and disable them temporarily to see if the issue persists.
  • Repair Office Installation: You can try repairing your Office installation. Go to Control Panel > Programs > Programs and Features, select Office 365, and choose "Change" then "Repair."
  • Recreate the Data Connection: Sometimes recreating the data connection can help. Delete the existing connection and set it up again from scratch.
  • PREET's avatar
    PREET
    Copper Contributor
    Feb 10, 2025

    Thanks for replying 

    I had already contacted Microsoft Support 2 days before

    firstly they repaired office but things don't work then we together reinstalled office 365 still problem persist . 

    so I told them that it seams that their is office software issue but they said No this is not Software Issue And given this link of Excel Community to get in touch 

     

    my previous  excel query working fine but new query from last few days not working and getting deselected automatically . i havnt installed any add ins 

    so need help if anybody can 

     

    • HCjac's avatar
      HCjac
      Copper Contributor
      Feb 12, 2025

      Hi, This definitely has to be a Microsoft problem.

      We have had this problem since the beginning of this year 2025. We have been using the same method since 2001 and have always been able to select "overwrite existing cells with new data, clear unused cellls" for the last 24 years. I have a 2024 system that shows "overwrite existing cells with new data, clear unused cellls" is selected just fine. If i make a copy and go into change the query, the "properties" will not longer keep this option.

      We use the subscription based office 365, so always have the the most update to date software from Microsoft. I call the office 365 support, but they said I needed to call Microsoft technical support. Preet could you let me know what number of support you called? jdr

      • PREET's avatar
        PREET
        Copper Contributor
        Feb 17, 2025

        hello Hcjac,

         

        I had not Called because i don't have any number directly to connect

        i used help support in excel 365 then contact support 

        then they connect it with chat and take system access through Quick Assist

        they checked my system even gone in Registry but nothing happen then they refered this link and said get help from excel community 

         

Resources