Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 20
Default Disable column only sorting in Excel

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.
  #2   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 35,218
Default Disable column only sorting in Excel

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
  #3   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 20
Default Disable column only sorting in Excel

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

  #4   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 35,218
Default Disable column only sorting in Excel

#2 sounds like a pretty specific warning to me. I'm not sure I could come up
with better words than MS did.

And if you're using xl2007, can't you make your data a table. (I don't use
xl2007 very often, but won't that make it so that you can't mess up that table.)

JimG wrote:

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


--

Dave Peterson
  #5   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 20
Default Disable column only sorting in Excel

It is to me also but not to some of my clients who have older versions and
novice users. I think we are going to include a warning/disclaimer page or
popup with our outbound data spreadsheets. Thanks for your help.

If you have Word / Access expertise, please take a look at my other post
this am listed under "Word" - "Mailmerge" titled "How do you connect Word
2003 to Access 2007 accdb database"

Jim

"Dave Peterson" wrote:

#2 sounds like a pretty specific warning to me. I'm not sure I could come up
with better words than MS did.

And if you're using xl2007, can't you make your data a table. (I don't use
xl2007 very often, but won't that make it so that you can't mess up that table.)

JimG wrote:

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


--

Dave Peterson



  #6   Report Post  
Junior Member
 
Posts: 3
Default

Hi Dave,
#2 sounds like a pretty specific warning to me. I'm not sure I could come up
with better words than MS did.

How can I disable that annoying warning message? Please. This guy's trouble is just to train people properly in the use of excel and in paying attention to what they are doing, but that hideous message when I am sorting just increases my work time.

Any solution to disable that warning message? THANKS.


Quote:
Originally Posted by JimG View Post
It is to me also but not to some of my clients who have older versions and
novice users. I think we are going to include a warning/disclaimer page or
popup with our outbound data spreadsheets. Thanks for your help.

If you have Word / Access expertise, please take a look at my other post
this am listed under "Word" - "Mailmerge" titled "How do you connect Word
2003 to Access 2007 accdb database"

Jim

"Dave Peterson" wrote:

#2 sounds like a pretty specific warning to me. I'm not sure I could come up
with better words than MS did.

And if you're using xl2007, can't you make your data a table. (I don't use
xl2007 very often, but won't that make it so that you can't mess up that table.)

JimG wrote:

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


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Table - Column not sorting on refresh Wendifer Excel Discussion (Misc queries) 0 May 15th 09 03:09 AM
Sorting a Pivot Table Column that is not the first column... [email protected] Excel Worksheet Functions 1 October 10th 07 09:02 PM
Disable Text to Column from popping up automatcally Newbee via OfficeKB.com New Users to Excel 0 January 31st 07 02:52 PM
How can I disable the automatic column breaks in Excel? Heather31337 Excel Discussion (Misc queries) 0 March 21st 06 07:42 PM
In Excel, sorting columns automatically by clicking column title Destiny Excel Discussion (Misc queries) 1 June 23rd 05 06:39 PM


All times are GMT +1. The time now is 11:50 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"