Why is Excel amending formatting itself, when i sort a sheet?
 

I have a fairly large spreadsheet that i need to sort regularly. Lately,
Excel is changing the row & column formatting when i do this.

I have version 2007, but it is saved as version 1997 - 2003 due to
compatibility reasons.

Can someone help resolve this issue please?

Why is Excel amending formatting itself, when i sort a sheet?
 

I would need more information to be able to assist. When you say Row and
Column formatting are you referring to the Width/Height of a column/Row?

If cells are merged (joined) you may experience some difficulties with this
when sorting. Also it may be something with word wrapping.

Can you tell me more about what kind of formatting is getting modifies and
provide some sample data perhaps?

Frank


"Reddhed" wrote:

I have a fairly large spreadsheet that i need to sort regularly. Lately,
Excel is changing the row & column formatting when i do this.

I have version 2007, but it is saved as version 1997 - 2003 due to
compatibility reasons.

Can someone help resolve this issue please?