I have 2 workbooks set up exactly the same way but with different data. When
I go to sort one spreadsheet, it keeps the last sort options that I had. On
the other spreadsheet, it will not save the settings so I have to pick them
each and every time. How can I avoid this? I cannot see what I have done
differently on one sprdsht than the other. I have even tried saving a copy of
the one that works and replacing the data with the sprdsht that doesn't. It
just keeps defaulting to the column that my cursor is in at the time.

If you're always doing the same kind of sort, you could record a macro when you
do it once and then just rerun that macro whenever you wanted.

ucfchick wrote:

I have 2 workbooks set up exactly the same way but with different data. When
I go to sort one spreadsheet, it keeps the last sort options that I had. On
the other spreadsheet, it will not save the settings so I have to pick them
each and every time. How can I avoid this? I cannot see what I have done
differently on one sprdsht than the other. I have even tried saving a copy of
the one that works and replacing the data with the sprdsht that doesn't. It
just keeps defaulting to the column that my cursor is in at the time.

--

Dave Peterson

Ahhhh - didn't even think of that - thanks! Works even better than doing a
manual sort.

"Dave Peterson" wrote:

If you're always doing the same kind of sort, you could record a macro when you
do it once and then just rerun that macro whenever you wanted.

ucfchick wrote:

I have 2 workbooks set up exactly the same way but with different data. When
I go to sort one spreadsheet, it keeps the last sort options that I had. On
the other spreadsheet, it will not save the settings so I have to pick them
each and every time. How can I avoid this? I cannot see what I have done
differently on one sprdsht than the other. I have even tried saving a copy of
the one that works and replacing the data with the sprdsht that doesn't. It
just keeps defaulting to the column that my cursor is in at the time.

--

Dave Peterson