sorting in a shared wkbk
 

XL2000 SR-1 on Win2K SP3. Strange behaviour sorting a list
from the menu or via code in a shared wkbk. Standard
rectangular list with headers (say A1:D50) without empty
rows/cols. Unshared wkbk = everything normal. Shared wkbk
= try sorting from the data menu, xl selects A2:IV50. With
activecell A1 - Edit/Goto/Special/Currentregion works
normally. Code to sort Range("A1").Currentregion... sorts
A2:IV50, headers recognized.

Also - any way to toggle sharing via code to update pivot
tables, sort (given above problem), etc?

Any ideas? Thanks,
Ken Smith