Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / General Excel Questions / March 2008

Tip: Looking for answers? Try searching our database.

Open Text Files in Excel, Changed Behavior

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
acbservices@gmail.com - 14 Mar 2008 17:14 GMT
For years I have opened text files in Excel using the right-click
"Open With..." in Windows. The files opened without triggering the
Import Text Wizard and were imported in one column. As of yesterday
(without any apparent changes to Excel or Windows), this behavior
changed. Now when text files are opened using "Open With...", Excel
"figures out" where it thinks the columns breaks should be. (Again the
Import Text Wizard is not triggered opening files this way.)

I've searched for settings that determine how Excel opens text files
by default, but found none.

Any ideas on how to go back to right-click opening the "one-column"
text files?

Thank you,
Patrick
acbservices@gmail.com - 14 Mar 2008 17:16 GMT
Sorry, I forgot to include... I'm running Windows XP and Excel 2003.

Patrick
pbartleby@gmail.com - 27 Mar 2008 15:14 GMT
I wound up solving this by reinstalling Excel. One of the Office
updates likely created the change. I will post if I can figure out
which update is involved.

-Patrick
pnosko - 27 Mar 2008 15:58 GMT
Patrick, thanks for posting this so I know I wasn't the only one
affected. It was in fact a recent security update that broke this
functionality.

In my control panel, it is listed as "Security Update for Excel 2003
(KB943985)v2:EXCEL".

See http://support.microsoft.com/kb/943985

When I removed this update, it worked as before. Proceed with caution.

Pete
yogesthebare@gmail.com - 28 Mar 2008 03:00 GMT
Pete,
I actually had to uninstall V1 and V2 of the below patch to get it to work
again ..

Carl

> Patrick, thanks for posting this so I know I wasn't the only one
> affected. It was in fact a recent security update that broke this
[quoted text clipped - 8 lines]
>
> Pete
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.