They just updated me at work to Office 2007. I'm having an issue with the sort function of excel 2007. This didn't happen in my old 2003 version.
I import a set of data with a header row. I add nother row above the header row to add more data (file date, etc.). I then freeze the panes at A3.
The first time I hit the sort button, all the cells below the header row (A2) are selected and I can sort the data normally. In my case I sort a column, add 0.00s to empty cells in that column to prepare to create a pivot table, then I want to sort the data by another column.
Here's where the problem starts. Again with the cursor at C3, the next time I hit the sort button, all the data cells get selected including the header row and the top row. I hit the "My data has headers" check box and it only removes the top row 1 selection but my header row is row 2, still selected. If I save the file and close it, then reopen. The sort function works fine *once*. The next sort request again chooses too many rows.
This used to work fine in the 2003 version but this one is driving me crazy. I know I can manually select the cells for sorting but I have to do this to numerous columns.
I've looked all over the net for a solution with out finding anyone else having this problem. I cannot go back to Excel 2003 because I have some sheets that are too large for 2003 to handle.
Any help will be greatly appreciated.
I import a set of data with a header row. I add nother row above the header row to add more data (file date, etc.). I then freeze the panes at A3.
The first time I hit the sort button, all the cells below the header row (A2) are selected and I can sort the data normally. In my case I sort a column, add 0.00s to empty cells in that column to prepare to create a pivot table, then I want to sort the data by another column.
Here's where the problem starts. Again with the cursor at C3, the next time I hit the sort button, all the data cells get selected including the header row and the top row. I hit the "My data has headers" check box and it only removes the top row 1 selection but my header row is row 2, still selected. If I save the file and close it, then reopen. The sort function works fine *once*. The next sort request again chooses too many rows.
This used to work fine in the 2003 version but this one is driving me crazy. I know I can manually select the cells for sorting but I have to do this to numerous columns.
I've looked all over the net for a solution with out finding anyone else having this problem. I cannot go back to Excel 2003 because I have some sheets that are too large for 2003 to handle.
Any help will be greatly appreciated.
