what is a group excel file and how do i disable so i can sort it?

[JR]

even when i copy and paste to a new worksheet it still holds onto the group
status so won't allow me to sort the data.

 

[Pete_UK]

"Group" can apply to worksheets which have been grouped together
(easily done by holding the CTRL key and clicking on another sheet
tab). To get rid of this setting, right-click on a sheet tab and
select Ungroup sheets.

It could also apply to a number of columns in the same sheet which
have been grouped together. To get rid of this setting you should
highlight the offending columns then click on Data | Group and Outline
| Ungroup.

Then save the file so that you won't have the same problem next time
you open it.

Hope this helps.

Pete