Formatting changes after refreshing data source in analysis for office

[Former Member]

searched blogs before posting

https://archive.sap.com/discussions/thread/3577951

https://archive.sap.com/discussions/thread/3585288

HI Experts,

I am Developing analysis for office and changing cell styles according to the requirement

but unfortunately everything is getting changed after refreshing the data source.

already i did lot of work

is there any steps i need to follow

any help would be appreciated

my template

after refreshing(default format)

Thanks,

Varun

[hackasaur]

go to Analysis Design tab > go to Crosstab > uncheck Apply Default Formats and Optimum Cell Width/Height

now your formatting won't be reset to the default SAP style when you refresh data source.