Forum Discussion
Helper IPower Query/Overwrite cell question
I didn't actualy get the problem solved. I did find an easy workaround. If some of you could actually see what its doing , I expect you could fix it. I am probably not doing a good enough job of describing it. But I am in a good spot with the form now. I appreciate the help. I am actually having a different issue that I may post when I have a chance.
Hi Missippy , thank you for the update. We're glad to hear you found a workaround. Could you please share the details here and mark it as 'Accept as solution' to help others with similar issues? If you have any other questions, feel free to post them (as a new post) in the community. We're always happy to assist.
Thank you.
Super UserHi Missippy To keep the "Overwrite cells" option selected, go to Data > Queries & Connections, right-click the query, choose Properties, and enable "Overwrite cells." Ensure you save the workbook after making this change to try persisting the setting. If the option resets, use a VBA macro to automate enabling "Overwrite cells" for all queries in your workbook.
Helper IThak you for taking the time to respond. That option is not available on my excel. Maybe I have an older version? I can write the macro though. I hadnt thought of that. Thanks again