LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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??
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sorting in a shared workbook Debs Excel Discussion (Misc queries) 0 June 24th 08 04:33 AM
Sorting Shared Workbook CrimsonPlague29 Excel Discussion (Misc queries) 0 June 26th 07 07:24 PM
Sorting in Shared Workbook Colleen Tinney Excel Worksheet Functions 0 July 13th 06 03:31 PM
Sorting & Filtering in Shared Workbook mixing up data Marius Excel Worksheet Functions 0 July 25th 05 02:53 PM
Sorting in a shared workbook Mark Jackson Excel Discussion (Misc queries) 1 June 7th 05 01:43 PM


All times are GMT +1. The time now is 02:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"