<div>
You may have reached the limits of Excel with that use. &nbsp;It will require a VBA script to run it by color being used a shared worksheet.<br />
<br />
<a href="http://office.microsoft.com/en-us/excel/HP100738491033.aspx" rel="ugc">http://office.microsoft.com/en-us/excel/HP100738491033.aspx</a><br />
<br />
<br />
Otherwise, I trust you have looked through these already and have found the 'how' to filter...it just is a problem with the shared part, correct?<br />
<br />
<a href="http://office.microsoft.com/en-us/excel/HA102125901033.aspx" rel="ugc">http://office.microsoft.com/en-us/excel/HA102125901033.aspx</a><br />
<br />
<a href="http://www.cpearson.com/excel/SortByColor.aspx" rel="ugc">http://www.cpearson.com/excel/SortByColor.aspx</a><br />
<br />

</div>


You may have reached the limits of Excel with that use.  It will require a VBA script to run it by color being used a shared worksheet.

http://office.microsoft.com/en-us/excel/HP100738491033.aspx [http://office.microsoft.com/en-us/excel/HP100738491033.aspx]


Otherwise, I trust you have looked through these already and have found the 'how' to filter...it just is a problem with the shared part, correct?

http://office.microsoft.com/en-us/excel/HA102125901033.aspx [http://office.microsoft.com/en-us/excel/HA102125901033.aspx]

http://www.cpearson.com/excel/SortByColor.aspx [http://www.cpearson.com/excel/SortByColor.aspx]



<div>
<div class="content wysiwyg-content">
I have a worksheet that when shared I can no &nbsp;longer sort or filter by color. &nbsp;I have tried this when there is &nbsp;no one else in the file and receive the same results. &nbsp;As soon as I unshare the option to sort and filter by color is back.<br />
<br />
Is this just the way it works or am I missing something.
</div>
</div>


I have a worksheet that when shared I can no  longer sort or filter by color.  I have tried this when there is  no one else in the file and receive the same results.  As soon as I unshare the option to sort and filter by color is back.

Is this just the way it works or am I missing something.

filtering by color in a shared workbook in Excel 2007

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.