Hi, I'm Bhavik. Welcome to JustAnswer. I'm reviewing your question now, and will reply back ASAP.
Please give me few examples to understand this problem in a better way.
Okay. How you are refreshing the Excel ?
Ok. I can see it now. When I refreshed it . My Comments were gone from column K
I got your requirement. I have started working on it.
I think, I found the trick.
Please check this excel .
Please try this.
That's great !! I would be waiting for your reply.
Is this is working fine ?
Okay, I will look into it.
I have added a macro code in it . Please try downloading it from below website :-
No, I think it is still not working. Please discard above message.
I have been trying different resolution but nothing seems to be working in this case.
I think I should opt out and allow other expert to look into it to see if they have any solution for this problem.
Please let me know if you have anything else for me and I am really sorry that I could not help you in it.
As I do not have access to the underlining query that is performing the refresh I cannot edit it for you but if you look at the connection (Via Data / Connections) and click on connection you see the location only extends to J, this is why you have the issue. Recreate the connection (as it needs to point to your Query) make sure the location includes K and then K will remain
Let me know please how you go