2007 Sort Dialog Box in Excel keeps growing.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Larry Cooke - 15 Apr 2008 08:06 GMT

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

Reply to this Message

Jim Rech - 15 Apr 2008 14:41 GMT

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.

Signature

Jim

| 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
[quoted text clipped - 11 lines]
|
| Larry

Reply to this Message

Walter Feigenson - 12 May 2008 04:52 GMT

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.

> 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
[quoted text clipped - 22 lines]
> |
> | Larry

Reply to this Message

Rate this thread: