Thanks for your reply Dave. But:

1. I do train my personnel but I have no control over my clients personnel
who think excel is a database and send us lots of datafiles in excel format.

2. In Excel 2007 there is a popup but not a clear specific warning. The
popup says "Microsoft Office Excel found data next to your selections. Since
you have not selected this data, it will not be sorted. What do you want to
do? Expand the selection or Continue with the current selection." A
novice user will often select "Continue".

What I want to do is to disable sorting a single column without sorting the
other columns. I have had clients accuse us of sending bad data when one
of their personnel did the type of sort described above.

We are going to start send a disclaimer with all Excel files and suggest
they use Access for a database not Excel.

Jim

"Dave Peterson" wrote:

I think it's a training issue.

The good news is that newer versions (xl2002+, I think) will give you that
warning that you want.

JimG wrote:

We get Excel files from others where a novice user has highlighted a whole
column and sorted it not knowing that it does not also sort the other
columns. (exp. sort a date of birth column as described and the correct
date of birth is no longer associated with the person's name). Is there a
way to disable this type of column sort or create a pop-up warning? I
cannot think of a reason this type of sort function is even in Excel. It
can create serious data problems.

--

Dave Peterson