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 ...
Thankyou so much for posting this! I'm having the exact same problem. "Overwrite existing cells" was checked in several power queries in different workbooks. One of the workbook was having a problem and now thanks to you I see that excel automatically unchecks it when I close the External Data Properties configuration popup. The other workbooks are fine.
I'll throw in that the option was removed from the Query->Properties menu, had to go to Data->Queries & Connections->Properties to find it again.
Thanks for posting Mohami. I am not finding the overwrite option in Data->Queries & Connections->Properties. Could you show me where you are seeing it. Thanks Jacchi
