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
gopir's avatar
gopir
Copper Contributor
Apr 10, 2025

Do we have any updates on this issue? From Microsoft or any work around?

  • mohami's avatar
    mohami
    Copper Contributor
    Apr 10, 2025

    Hi gopir,

    I found a workaround in reddit - start a recording a macro, open the Data-Properties window and select the Overwrite option. Stop the recording.  Edit the macro and change the refreshstyle to 'xlOverwriteCells'.  Run the macro and it fixes the selection option.  Good luck!

Resources