Cannot sort in excel after importing data from access query

Question

Hi.

I have a spreadsheet in Excel 2010 which I import data for the current week from an access database query.

I then copy some formulas from the week before to give me the analysis for the week.

Imported cells are columns A-K and the formulas added are L-T.

If I select A-K it will sort without a problem, however if I select the whole range A-T and try and sort by column S is will not allow me to and the sort buttons on the ribbon are shaded out.

The only thing that I can see is that the data I have downloaded appears in "Table style medium 9", but when I copy the formulas it does not have any table formatting. However it will not allow me to change this to the "Table style medium 9" format to see if this is the problem or not.

Can anyone help?

Thanks

Aaron

Answer 1

Thanks.  But this did not work.  The Convert to range button is shaded out too.

Answer 2

Hi,

Try converting back to the range from existing table format. To do this Go to 'Design' (under Table Tools on extreme right) --> Select 'Convert to Range' under Tools.

PS: It has nothing to do with access import, it's related Excel Data Format/Design.

Hope it helps !

Regards

Ashish Jain