View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
AZ AZ is offline
external usenet poster
 
Posts: 3
Default Sorting Datain a Shared Workbook

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??