Forum Discussion
Preserve Excel Column formatting on Refresh
Hello Anonymous
in your scenario you are changing column names on every query? The formatting should always be connected to column names... so whenever the name is changed or you remove a formatted column and insert it again after one refresh, the formatting is lost for sure. What you could do is to write a makro that is executed after your refresh, that setups the formatting again.
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
Hello Anonymous
in your scenario you are changing column names on every query? The formatting should always be connected to column names... so whenever the name is changed or you remove a formatted column and insert it again after one refresh, the formatting is lost for sure. What you could do is to write a makro that is executed after your refresh, that setups the formatting again.
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
Thanks the Macro was the way to go. Works quite nicely.
Chami