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.
Helper IIt has not corrected my problem. Even charging it manually doesn't correct the problem. When I download the queries, some of them change the formula on some of the bottom few. I have found a work around that allows me to quickly correct the cells with the incorrect formulas. Thanks for all the suggestions and energy spent on my issue.
Community SupportHi Missippy , Thank you for reaching out to the Microsoft Community Forum.
Since the Overwrite Cells option and VBA didn’t fully solve it, a more reliable fix is to keep your formulas separate from the query output. The best way to do this is to either load each query to its own sheet and reference it from your main sheet with formulas like =Query1_Data!A2 or place your queries in dedicated columns and keep your formulas in different, non-overlapping columns. This keeps Excel from touching your formulas when the data refreshes.
If you want to quickly fix overwritten formulas each day, you can also automate your workaround with a small macro. Just press ALT + F11 to open the VBA editor, insert a module and paste the code. Example:
Sub RestoreFormulas()
Range("C2:C100").Formula = "=A2*B2" 'Update with your actual formula and range
End Sub
Run it with ALT + F8 after your queries refresh. Also, it’s worth checking your Excel version, older versions like Excel 2016 don’t handle these features as well, so upgrading to Microsoft 365 might help in the long run.
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.