I have imported data from a sql table, when I try and sort a selection of data brought into excel it is automatically taking all the data and not just the selection. The tick for my data has headers is automatically on and greyed out.
Are you sure you imported the data or did you create a link to sql. If it is a link then it will not allow you to work with a subset of the data because it would effect the data on the sql database.
166 views
Usually answered in minutes!
×