Power Query does not pick up my formatted refreshed data

[mrnassaro]

Hello Experts!

I have a power query file that I am using currently. This file pulls all the data that I want and I am happy with it. However, in the source files, my team and I sometime change the color of a cell or strikethrough another. those don't get reflected in the power query file.

does anybody has a solution for that?

I would really appreciate your help!

Thanks!

 

[alansidman]

Power Query does not maintain color format or other types of special formatting.

 

[mrnassaro]

Is there anyway that I could incorporate a VBA code or something?

 

[alansidman]

Once you have your output from PQ, you could format your data with VBA. To do this, suggest you record a macro and then if you need to fine tune it, post it here for our "experts" to assist.

 

[mrnassaro]

Once you have your output from PQ, you could format your data with VBA. To do this, suggest you record a macro and then if you need to fine tune it, post it here for our "experts" to assist.

Awesome! Thank you very much