hi Ron
when i right click i dont see un group but i do see veiw code

"Ron Coderre" wrote:

Excel is not-so-subtley telling you that you have at least 2 sheets grouped.
Grouping can be handy for effecting the same change through multiple sheets
at once (eg putting the same text in cell A1 of all grouped sheets). However,
when sheets are grouped, some functionality is disabled....Sorting is one.

To fix the problem:
Right-click on one of the sheets within the group and select: Ungroup
OR
Just click on any sheet tab NOT in the group.

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"neil in cornwall" wrote:

when i sent an excel spread sheet from home to work the sort function is no
longer available the header of the page has now got [GROUP] at the end of the
title can any one help?????