Persistent Text to Columns...

[RickGreg]

I've been using the Text to Columns command recently and it is driving me
crazy.

Each time I use it, every subsequent time I paste something in Excel, it
parses the contents of my paste to columns.

This behavior persists even when I open a new workbook.

The only solution I've found is to quit/restart Excel, after which
everything is back to normal.

Any ideas?

[Excel 11.3.3 (061213) OSX 10.4.10]

Thanks in advance!

 

[CyberTaz]

I'm not certain, but since the T-T feature doesn't involve the clipboard I
think you may have some degree of OS interaction going haywire... especially
since copying/cutting other material replaces whatever is currently on the
clipboard. Based on your version info, the first thing I'd suggest is that
you download & [re]apply the current Office 11.3.5 updater, run Disk
Utility - Repair Disk Permissions & see if that makes a difference.

If no improvement post back with a bit more detailed description of how
you're going about things.

 

[RickGreg]

I'm not certain, but since the T-T feature doesn't involve the clipboard I
think you may have some degree of OS interaction going haywire... especially
since copying/cutting other material replaces whatever is currently on the
clipboard. Based on your version info, the first thing I'd suggest is that
you download & [re]apply the current Office 11.3.5 updater, run Disk
Utility - Repair Disk Permissions & see if that makes a difference.

If no improvement post back with a bit more detailed description of how
you're going about things.

Thanks. That seems to have worked. FWIW, I recall the same thing happening
in years past with vastly different versions of OS and Office. Odd.

 

[CyberTaz]

I'm not certain, but since the T-T feature doesn't involve the clipboard I
think you may have some degree of OS interaction going haywire... especially
since copying/cutting other material replaces whatever is currently on the
clipboard. Based on your version info, the first thing I'd suggest is that
you download & [re]apply the current Office 11.3.5 updater, run Disk
Utility - Repair Disk Permissions & see if that makes a difference.

If no improvement post back with a bit more detailed description of how
you're going about things.

Thanks. That seems to have worked. FWIW, I recall the same thing happening
in years past with vastly different versions of OS and Office. Odd.

Odd? Not really... Each update to the OS involves *changes* so the apps get
updates accordingly. "Updates" are actually *patches* that fix/modify
aspects of the software. If the OS updates get applied & the app updates
don't (or vice-versa) the 2 quite likely no longer "sync" the way they need
to. In your case Office was two steps behind OS X - quite frankly, I'm glad
you didn't have more serious problems

Thanks for confirming the fix!

Regards |:>)
Bob Jones
[MVP] Office:Mac