Connecting to SCCM Report
 

I'm connecting the spreadsheet to the URL of a report, then, did some
graphical stuff, conditional formatting, and, summing to it, to make it look
pretty.

BUT...if I refresh it, it changes all the stuff back to the original, losing
all my formatting.

How to keep just the link, but, also my formatting, and be able to refresh
to get latest data?

Thanks.