Hi,
Hope someone can assist me with this one as I am getting a headache!
My power query produced a table of information (3 columns). I ticked both the 'Preserve column sort/filter/layout' and 'Preserve cell formatting' boxes located in 'Properties' under the 'Data' tab. Which works. But then I needed to start highlighting rows. I highlighted a row/individual cells (using 'fill colour') and saved it. However, when I come to refresh the table the highlight disappears from all cells except on the last column. For example,
instead of seeing this:
I see:
I have started the power query afresh and reticked the preserve boxes but still the highlight is disappearing.
Any ideas?
Many thanks
Hope someone can assist me with this one as I am getting a headache!
My power query produced a table of information (3 columns). I ticked both the 'Preserve column sort/filter/layout' and 'Preserve cell formatting' boxes located in 'Properties' under the 'Data' tab. Which works. But then I needed to start highlighting rows. I highlighted a row/individual cells (using 'fill colour') and saved it. However, when I come to refresh the table the highlight disappears from all cells except on the last column. For example,
instead of seeing this:
| a | b | c |
| 1 | 2 | 3 |
I see:
| a | b | c |
| 1 | 2 | 3 |
I have started the power query afresh and reticked the preserve boxes but still the highlight is disappearing.
Any ideas?
Many thanks
