The number of columns on a given worksheet is fixed based on the version of
Excel you are using. The only way I know of to have the excess go to another
sheet is through VB Coding. I have an Excel workbook that is capable of
dealing with 'excess' columns from .csv type files, but that's not going to
help you with importing directly from Word.

"CBER" wrote:

When importing text from a word form the Excel worksheet doesn't provided
enough columns to import all the data. Is there a way to increase the number
of columns in a worksheet or have any data go directly to another worksheet.