I have a set of data in a worksheet which I've formatted as a Table within Excel 2007 using the "Format as Table" functionality.

When I choose to sort the data within said Table by say Column C, the row colors also resort changing the layout / view of the table making it very difficult to read. When I do this in a new workbook, it behaves normally.

I don't know why in this is happening and am curious to "fix" this issue. I can't post a sample of the workbook due to the nature and data contained within it, but am looking for any ideas on how to resolve it.

Thanks in advance for any ideas on what I can do to fix this.

Chris