View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Rich Rich is offline
external usenet poster
 
Posts: 298
Default Question: How Excel opens text files

Hi Gary,

Thanks for the reply. I am aware of the work-around. I am hoping to get
confirmation that MS08-014 is responsible for this change in Excel's
behaviour.

Thanks,

Rich



"Gary''s Student" wrote:

Do not open the file by right-clicking the icon and selecting Open With...

First open Excel and then:

Data Import External Data Import Data
this will invoke the Import Wizard. Instruct the Wizard to put everything
in column A.
--
Gary''s Student - gsnu200776


"rich" wrote:

Hello,

I provide end-user support. I currently have a case where the Excel is
opening a text file differently. We pushed out patches last Monday which is
when the change occurred. Not seeing how this may have affected the user.
He appears to be the only person affected. Others in his group did not
install the patch and nothing has changed.

From an Explorer window, user right-clicks on text file and chooses "Open
With...".
Excel used to open and load the text file and each row in column A.

Now, opening the file the same way, Excel loads and formats the text file in
multiple columns. If the text import wizard is actually doing this, it is
running in the background with no dialog being displayed.

User prefers the origina method where everything is in 1 column. Is there a
way to control how Excel opens/loads/formats text files? Any idea if
MS08-014 has changed the behavior?

TIA,

Rich