Excel.Tips.Net: Can’t Sort Imported Data

By Allen Wyatt for Excel.Tips.Net

Martin is importing data into a worksheet from an SQL view; it comes in perfectly. Excel automatically creates a defined table using the imported data. Martin then inserts new columns in the middle of the table so he can start to work with the data, but once these new columns are inserted he cannot sort the worksheet—the option is grayed out.

Martin is wondering why this is happening and how to fix it.

The problem is probably due to the fact that the data is being imported as a defined table. Defined tables can have some “peculiarities” (shall we say) that affect what you can and cannot do with them. You can figure out if this is what is causing the problem by following these steps:

#1. Make sure you select a cell within the data table.

Article Continued Here

This post is excerpted with permission from Excel.Tips.Net

Subscribe to the Free ExcelTips Newsletter with the links below

(for those using Excel 97 through 2003)

(for those using Excel 2007 through 2010)

Stop Responding to Threats.
Prevent Them.

Want to get monthly tips & tricks?

Subscribe to our newsletter to get cybersecurity tips & tricks and stay up to date with the constantly evolving world of cybersecurity.

Related Articles