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.
Community SupportHi Missippy , Thank you for reaching out to the Microsoft Community Forum.
Since the "Overwrite Cells" setting does not persist automatically in your Excel version, the best solution is to use VBA to enforce it every time you refresh queries. You can use the macro provided by SacheeTh , which ensures all queries overwrite cells when refreshed. If you prefer a manual method, consider converting your queries to tables, as Excel automatically overwrites table rows.
RefreshStyle Property [Excel 2003 VBA Language Reference]
Thank you SacheeTh , Akash_Varuna for providing valuable answers.
If this helped solve the issue, please consider marking it 'Accept as Solution' so others with similar queries may find it more easily. If not, please share the details, always happy to help.
Thank you.