Results 1 to 3 of 3
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Disappering Tabs (Office 97)

    Hi

    Can anyone tell me why , when I import a text file csv all the tabs in the worksheet Disappear?

    Thanks in advance
    If you are a fool at forty, you will always be a fool

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Disappering Tabs (Office 97)

    What you see is NOT a disappearing of all tabs.

    When you import a text file (any text file) excel opens a *new* workbook into which the file is imported. Since text files can not contain more than one sheet, this is what you get: a one-sheet workbook.

    Any workbooks you had open when you started the import are still there, check out the Window menu.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Disappering Tabs (Office 97)

    Hi pieterse

    Thanks very much for that, of course you are absolutely correct.

    Thanks again
    If you are a fool at forty, you will always be a fool

Posting Permissions

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