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.
This post is excerpted with permission from Excel.Tips.Net
Subscribe to the Free ExcelTips Newsletter with the links below