Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel 2003 wont sort when shared
Hi,
I am trying to share a worksheet, i have data in one colomn with a few rows and then data in another colomn with a few rows. When i go to data sort it selects the whole worksheet which i do not want, i just want the first colomn with the rows sorted. When the worksheet is un-shared then the sort function works fine. please in desperate need of help, have posted on Mr Excel but no help there. -- Gino Not clued up on windows |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel 2003 wont sort when shared
Gino, The following restrictions are in place on a shared workbook; at least in Excel 2002. You won't be able to add or change the following: merged cells, conditional formats, data validation, charts, pictures, objects including drawing objects, hyperlinks, scenarios, outlines, subtotals, data tables, PivotTable reports, workbook and worksheet protection, and macros. This is what is most likely causing the sort to default to the entire sheet rather than allowing you to sort a limited range. HTH -- Casey ------------------------------------------------------------------------ Casey's Profile: http://www.excelforum.com/member.php...fo&userid=4545 View this thread: http://www.excelforum.com/showthread...hreadid=559346 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting data on protected worksheet | Excel Discussion (Misc queries) | |||
Do I have a corrupt shared Excel 2003 File? | Excel Worksheet Functions | |||
How do I open a Quattro Pro 7.0 file in Excel 2003 | Excel Discussion (Misc queries) | |||
Sort Ascending button - Excel 2003 | Excel Discussion (Misc queries) | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) |