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 ...
I went on ChatGPT and it gave me a fix that works:
🛠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:
- Go to:
File → Options → Data - Under Show legacy data import wizards, check:
✅ From Access - Now go to Data → Get Data → Legacy Wizards → From Microsoft Access Database
- The old interface should remember the overwrite setting just like it did in 2002–2013.
🧩 TL;DR
- 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.