How to define the column width in EPMFormattingSheet

[Former Member]

I need to adjust the column width for all my columns, I tried to modify it directly in the worksheet, but it cannot be maintain after I refresh the worksheet since I apply the EPMFormattingSheet, I wonder where should I define the column width? since the column width is not display when I right lick the cells  in the EPMFormsttingSheet.

Thanks

[former_member190501 · Accepted solution]

Hi,

Check Auto Fit Column width from EPM-->Options-->Sheet Options-->Formatting.

Or Uncheck this option and adjust column width in the spread sheet as per your requirement this setting will remain even after refresh.

Thanks,

Raju