I have had this same problem in two different installations of Excel on two
different machines. It's not just the sort dialog box, the remove duplicates
dialog has the same problem. It also doesn't always remember the previous
settings (e.g. "My data file has headers").

I do a lot of sorting and list cleaning, and this is a major annoyance.
Frankly, the only reason I use Excel 2007 is for the remove duplicates
feature. These bugs weren't in the previous versions, but removing dupes
wasn't so easy.

While I'm here, I'll mention another problem I haven't found the solution
for - in Outlook 2007, when replying to a message, the screen often scrolls
into never-never land and what I'm typing is completely off-screen. Again,
identical problem on two different machines.


"Jim Rech" wrote:

Very odd. I tried to reproduce the problem in Excel 2007 by doing several
sorts. But each time the Sort dialog opened in the same position and at the
same size as it was at the last sort. And when I start a new Excel session
it's back to its original small size. Sorry, no help here.

--
Jim
"Larry Cooke" wrote in message
...
| I've been using Office 2007 for a few months now, recently I had to
replace
| my laptop and since installing it on the new laptop, I've had this
annoying
| issue when I try to use the sort command on the new machine. Old machine
was
| XP as is the new one if that matters and this wasn't an issue.
|
| Each time I use the sort command, the dialog box opens to a larger size,
| eventually it grows to full screen and I have to resize it to something
more
| manageable. It's a major pain when it's full screen, I can't see the
columns
| I want to sort. I suppose I could take the time to memorize the columns
| prior to hitting Alt-D-S, but it's an old habit to use the keyboard
shortcut
| without thinking. :-/
|
| Thanks,
|
| Larry