If our workbook is not shared we can sort selected cells. If it is shared the sort affects the entire rows.
Is there a way to sort selected cells only in a shared workbook?
TIA
Lidna
If our workbook is not shared we can sort selected cells. If it is shared the sort affects the entire rows.
Is there a way to sort selected cells only in a shared workbook?
TIA
Lidna
Hi Inivin,
Honestly, I don't have much experience with shared workbooks. So, this is a shot in the dark. But, since you haven't gotten any other responses in 8 hours, this might be as good as you're going to get, and it will cost you nothing to try my idea.
How about ... unshare the workbook, sort the column, share the workbook again?
If you are unable to un-share the workbook, another option is to copy the selection to a blank sheet, Sort, then replace the sorted cells over the original.Originally Posted by lnivin
hth
---
Si fractum non sit, noli id reficere.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks