filtering by color in a shared workbook in Excel 2007

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.
dbartgisAsked:
Who is Participating?
 
Patrick MatthewsConnect With a Mentor Commented:
When workbooks are shared, some features are switched off.  This is one such case.

In any event, the consensus opinion of the Experts here is that you should avoid use 'share workbook' anyway, as it makes workbooks extremely vulnerable to corruption.
0
 
PlantwizCommented:
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


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://www.cpearson.com/excel/SortByColor.aspx

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.