Macro that sorts not working

[David P.]

We have a 4 computer peer to peer network. The "server" computer has it's own
drive letter that all the computers read (I am a novice as you might tell).
On a spreadsheet that we use for customer information and invoicing I have a
macro that opens another workbook, activates that other workbook, pastes
information from the original workbook, sorts that information by activating
a macro stored in that particular workbook, closes and saves that workbook,
then activates the original workbook again.

My problem is this. That macro scenario above works on the "server" computer
but not on the others. When I get to the macro on the second workbook refered
to above the macro freezes and asks to debug when it gets to this point:

Selection.Sort Key1:=Range("A8"), Order1:=xlAscending, Header:=xlNo, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal

Any suggestions as to why it is freezing here on the other computers? Your
help is appreciated.

 

[Dave Peterson]

My first guesses:

Are you sure you have the correct range selected?

And does that other pc use xl2002 (or higher) or is it using xl2k (or lower).

if it's not up to xl2002, then remove that "dataOption1" portion--it was added
in xl2002.