Forum Discussion
"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 ...
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
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
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
Found from using ChatGPT
TLDR
• You're not imagining it — this did work consistently for 20 years.
• Microsoft changed the underlying import engine.
• The new system is more cautious and doesn’t persist all settings.
• You can bring back the old behavior by enabling legacy wizards in Excel settings.Cloud-First Development In Microsoft 365:
• Excel is being developed with collaboration, sync, and error prevention in mind.
• User actions like overwriting cells are guarded more cautiously, especially in shared/cloud files.Preet, found the answer:
________________________________________
What You Can Do
Switch to Legacy Wizard (Classic Behavior)
You can re-enable the old import wizard that does remember settings like it used to:
1. Go to:
File → Options → Data
2. Under Show legacy data import wizards, check:
From Access
3. Now go to Data → Get Data → Legacy Wizards → From Microsoft Access Database
4. The old interface should remember the overwrite setting just like it did in 2002–2013.