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

Cell format change after refreshing data

219 Views

Hi,

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: https://answers.sap.com/questions/11015959/formatting-changes-after-refreshing-the-workbook.html

Version. 2.7.400.87314
Excel: 2016