sorted but did not select all columns

[Guest]

The safety group at my work share a excel sheet that sits on a shared server,
someone from the team opened up a sheet and just sorted 3-4 columns and it
did not sort the rest of the columns which messed up all the data on the
sheet then saved it and exited is there any way to remove the sort to where
it goes back to the original way it was? other than restoring that folder
from a previous day?

 

[Earl Kiosterud]

Confused,

Sorry, but there's no way any tool could figure out which rows go with which rows. The
person that sorted it performed the "Sort of Disaster," which Excel will shamelessly do. I
recommend you remove the quick-sort buttons from everyone's toolbars. They're seductively
simple, but the Sort of Disaster isn't funny, and many have wept. The Excel development
people can't decide if Excel should be an easy-to-use user-proof tool, or a more
sophisticated one. So they limply do a little of both. It's quite unfortunate.

If sorting is required by some users, consider a macro that does the sort. Also consider
keeping a read-only master copy, and who needs update capability for that copy. Turning
casual users loose with Excel has its risks.

 

[Trevor Shuttleworth]

Short answer ... no.

Regards

Trevor