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 OVERLAPPED . EARLIER IT WAS WORKING FINE  

 

LIKE IN SCREEN SHOT WE HAD SELECTED "OVERWRITE........" TAB BUT WHEN WE PRESS OK AND REOPEN IT IT GET DESELECTED 

PLEASE HELP ON THIS

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

Resources