Skip to Content
Nov 18, 2019 at 02:43 PM

Cell format change after refreshing data



In my reports I have created an extra column where I do a spimple calculation which I want to display as percentage.
I change the format of the cell to Percentage and drag it down to the entire column. But after refreshing the data, only the original cell keeps the formatting and the rest of the cells switch back to default formatting.

How can I make the formatting stay after updating?

I found an old thread about this but we no answer:

Version. 2.7.400.87314
Excel: 2016