+ Reply to Thread
Results 1 to 5 of 5

Excel 2007 Import from text on XP vs 7

  1. #1
    Registered User
    Join Date
    10-04-2012
    Location
    Yonkers, New York
    MS-Off Ver
    Excel 2007
    Posts
    6

    Excel 2007 Import from text on XP vs 7

    An XP user in my office must go "Data -> From text -> (select file) -> Open" in order to import text into an excel spreadsheet. A windows 7 user, however, does not need to import the text file from Excel. All the windows 7 user must do is open the text file, and it automatically presents itself in the spreadsheet without having to import from excel.

    Weird thing is, on MY windows 7 machine, opening the same text file goes right to text, so... how does the windows 7 user's PC *know* to open the text file in excel? Excel is NOT the default program for text files. Right-clicking and opening with excel does in fact open it in excel, but not so in XP. In XP right-clicking and opening with excel just launches excel but doesnt open the file (just see blue screen with option to open a file). The XP user MUST have excel open, and then import.

    Is this an operating system variance? all searches to find an answer to this say that my XP user is doing the right thing, implying that the Windows 7 user conveniently doesn't have to go through the steps in the import-from-text process to get the same end result.

    Please advise, i dont know why this would be so stubbornly different between the two OSs.

    Thankya thankya

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,974

    Re: Excel 2007 Import from text on XP vs 7

    couple of questions...
    1. are you trying to open the txt file from within excel?
    2. which version of excel does the XP machine have, and which version does the W7 have?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    10-04-2012
    Location
    Yonkers, New York
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Excel 2007 Import from text on XP vs 7

    1. yes on the XP machine, no on the w7 machine
    2. both have excel 2007

    I apologize if my question was a little convoluted. I want to be able to right-click text files and open with excel on the XP machine in the same way that I can on the W7 machine.

    As it stands now, it is slightly more convenient to open a text file on windows 7. Being able to open it in XP requires that you go into excel first.

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,974

    Re: Excel 2007 Import from text on XP vs 7

    i dont have access to an XP box, so i cant test anything, but it is probably something to do with 7 being far more advanced and "interlinked" than XP

  5. #5
    Registered User
    Join Date
    10-04-2012
    Location
    Yonkers, New York
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Excel 2007 Import from text on XP vs 7

    yea that's what i (sort of) thought, the ladies needing to open the text files on their respective computers seem to think that this difference is the biggest deal in the world...

    thanks for your response, much appreciated

    and if anyone else has input, that too would be welcome!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1