Search code examples
excelexport-to-excelexcel-2003sharingworksheet-function

Using "Text to Columns" in a shared Excel 2010 worksheet

I have a shared Excel worksheet (using .XLS due to compatibility issues), which I use with Excel 2010. One of the tasks in this worksheet is to enter a series of values from a Notepad file, which are tab/space separated. If I just do a copy from the notepad to the excel sheet, the "Text to Columns" is NOT ENABLED, and cannot be used.

Is there some other way to do this, without "un-sharing" Excel sheet? (which causes issues with the history and if the same is open with other users)

Solution

  • I don't find it on the limitations list, but I assume this is one of the features that is disabled on shared workbooks:

    Features that are unavailable in shared workbooks

    I'm afraid you'll need to un-share the workbook before being able to use the features listed.