Sorting Datain a Shared Workbook

[Az]

I have an odd problem. I have a spreadsheet with 40 rows of data with columns
from A to V. I then have two blank columns and then in columns Y to AB I have
data down to row 6 (summary cells).

Whenever I try to sort the data in columns A to V, the sort function
automatically adjusts the sort range so that the ENTIRE columns in the
worksheet are sorted, including those in columns Y to AB.

This only happens when I use the file as a shared. When I have exclusive
access the sort works fine???

Any suggestions??

 

[Jon Peltier]

Most people who have tried shared workbooks eventually give up in
frustration due to limitations and unexpected behavior.

You could probably unshare the workbook, do your stuff, then share it again.
Or you could keep the workbook unshared and train the users to keep the file
open for only a couple minutes at a time.

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009-06-ACNJ/AdvExcelConf200906ACNJ.html
_______

 

[Macro Matt]

I use shared workbooks all the time - they are good if you have the patients to learn all the differences between them and unshared workbooks.

To get around your problem, you could put that Y1:AB6 data below or above the sorted data, or on another tab. Microsoft have designed it so that you can't move cells around, but can filter/sort/move/add/delete entire rows and columns.