Format Changing When Copy Pasted to Different Excel

[knobsdog]

I have a general question regarding a basic table being output to Excel.  I have users that are taking parts of the output, copying and pasting into other reports and they're reporting the formatting is changing when they do that.  Is there something I should be setting in the basic table, vertical layout tool or something else to keep the output format when they copy/paste into another excel doc?

[skeen503979]

@knobsdog 

Have they tried to paste the value only.?

CTLR+ALT+V,  then select "Values"

[knobsdog]

Yes we've tried  values only but we lose the formatting, formatting only and keep formatting but it takes the rows from grey and white to bright red and white.