Page 1 of 2 12 LastLast
Results 1 to 15 of 19
  1. #1
    Lounger
    Join Date
    Jan 2001
    Location
    Tucson, Arizona, USA
    Posts
    45
    Thanks
    0
    Thanked 0 Times in 0 Posts

    File Opening Problem (Excel 97 SR-2)

    I have a password-protected spreadsheet with data that I need to access both at work and at home, so I keep it on a floppy disk in my briefcase. This morning when I tried to open it, after typing in my password, the file flashed briefly in Excel and then disappeared. Although the Excel title bar lists the file name, there are no open windows in Excel.

    I have not editted this file since the last time I successfully opened it, which was only about a week ago. I opened the file and closed it without saving it, since I had made no changes. There is only one other spreadsheet on the disk, and it works fine. The floppy disk is not the problem, because I get the same results when I copy the problem file to my hard drive and attempt to open it from there.

    Is there anything that can be done about this? Is there any way to get my data out? There are no formulae or macros in this spreadsheet, just one worksheet with a table of data.

    Help! Please.
    Thanks,

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: File Opening Problem (Excel 97 SR-2)

    First, check to see if the window is open, but off the screen. Right click on the Excel Icon on the task bar, and if the Maximize command is enabled click on it.
    Legare Coleman

  3. #3
    Lounger
    Join Date
    Jan 2001
    Location
    Tucson, Arizona, USA
    Posts
    45
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: File Opening Problem (Excel 97 SR-2)

    No, it's nowhere. In Excel, when I click on the Window menu item, everything is grayed out and there are no windows listed. I generally maximize everything I'm working on by default (the company won't get us monitors bigger than 17"), so it was already maximized and not off the screen anywhere.

    Thanks anyway. Any other ideas?

  4. #4
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts

    Re: File Opening Problem (Excel 97 SR-2)

    Try Format =>Sheet=>Unhide to see if there are any hidden sheets

    To check that the file really is open can you try
    Tools => Macro => Visual Basic Editor

    Check that your workbook appears in the Project window as VBAProject(your-file-name).

    If it is there then double click it and select the Workbook object in the project window. You will now see the properties of your workbook in the properties window. Check that isAddIn is false.

    StuartR

  5. #5
    Lounger
    Join Date
    Jan 2001
    Location
    Tucson, Arizona, USA
    Posts
    45
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: File Opening Problem (Excel 97 SR-2)

    Everything under the Format menu is grayed out, except the Row, Column and Sheet submenus, and all of their items are grayed out. No hidden sheets, no unhidden sheets.

    I tried the Tools->Macro->Visual Basic Editor, and it brought up a totally empty window (well, you know, it had the expected menus and buttons, but no content).

    Incidentally, when I right-click on the file in Windows Explorer and choose Properties, the Summary tab just says "No summary information is available."

    Thanks. Any other ideas? I'm at a loss, here.

  6. #6
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts

    Re: File Opening Problem (Excel 97 SR-2)

    It's starting to sound like your workbook has been closed!

    In the visual basic editor can you just truy View =>Project Explorer, in case the window isn't displayed at the moment.

    StuartR

  7. #7
    Lounger
    Join Date
    Jan 2001
    Location
    Tucson, Arizona, USA
    Posts
    45
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: File Opening Problem (Excel 97 SR-2)

    I'm starting to think there's no hope. <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15> <img src=/S/bummer.gif border=0 alt=bummer width=15 height=15> <img src=/S/surrender.gif border=0 alt=surrender width=31 height=23> <img src=/S/igiveup.gif border=0 alt=igiveup width=31 height=23>

    View->Project Explorer shows no projects to explore. The Window menu in VBE, like in Excel, is entirely grayed out: no windows, displayed or not.

    Oh, before somebody starts suggesting it, I've already virus-checked (with 2 different checkers), defragged and scan-disked the floppy disk. No luck there, either.

    Again, thanks... <img src=/S/crossfingers.gif border=0 alt=crossfingers width=17 height=16> <img src=/S/hairout.gif border=0 alt=hairout width=31 height=23> <img src=/S/help.gif border=0 alt=help width=23 height=15>

  8. #8
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Ankeny, Iowa, USA
    Posts
    298
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: File Opening Problem (Excel 97 SR-2)

    out of curiosity, how large is the file on the floppy? Also, when you open it now does it still ask you for your password? Could you try to open the file, save it without a password and open it in another app like StarOffice or something to see if the contents show up?

  9. #9
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts

    Re: File Opening Problem (Excel 97 SR-2)

    You could also try opening the Excel file in Word, it should be able to show the data as a table.

    StuartR

  10. #10
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: File Opening Problem (Excel 97 SR-2)

    One more thought. Try opening Excel, then Select Open from the File menu. Navigate to the file, then select it. Hold down the Shift key and click on the OK button. If that opens the file, then there is a macro that is either closing the file immediatley or causing an error that closes the file.
    Legare Coleman

  11. #11
    Lounger
    Join Date
    Jan 2001
    Location
    Tucson, Arizona, USA
    Posts
    45
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: File Opening Problem (Excel 97 SR-2)

    A worthy, valiant attempt, but I got the same results: I entered my password when prompted, but the file won't open.

    Argh!

  12. #12
    Lounger
    Join Date
    Jan 2001
    Location
    Tucson, Arizona, USA
    Posts
    45
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: File Opening Problem (Excel 97 SR-2)

    The file is only 21Kb. It doesn't have any formulae or macros, and the one sheet only has a table of data approximately 25-30 rows and maybe 6 or 7 columns.

    When I try to open the file, yes, it asks for my password, but nothing happens after that. I can't save it without the password because Excel doesn't think I have the file open: there's nothing to save.

    I'll upload a picture of what Excel looks like after I "open" the file. As you can see, the window title indicates that there is a file open, but the Window menu shows there are no windows.

    Thanks to all for the assistance, but so far it's been to no avail. I will, of course, still gratefully accept any more tips offered, and will try them all until I find a solution (at least, until everybody <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15> and <img src=/S/surrender.gif border=0 alt=surrender width=31 height=23>).
    Attached Images Attached Images

  13. #13
    Lounger
    Join Date
    Jan 2001
    Location
    Tucson, Arizona, USA
    Posts
    45
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: File Opening Problem (Excel 97 SR-2)

    A good idea, but Word tells me that it "cannot convert password protected documents".

    I also tried some other apps to see if I could open the file. Text editors, of course, are wothless. PowerPoint gave me this message when I tried to insert the spreadsheet into a slide:
    <hr>The server application, source file, or item can't be found. You should reinstall the server application.<hr>
    Access didn't recognize the file type. Lotus Notes just gave a generic error message. Any other apps I could try to open this file in?

  14. #14
    New Lounger
    Join Date
    Nov 2001
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: File Opening Problem (Excel 97 SR-2)

    You may be attempting to open an addin where the extension on the file was manually changed from ".xla" to ".xls". Try manually changing to "*.xla" in Explorer (AFTER making a backup copy).

    <img src=/S/salute.gif border=0 alt=salute width=15 height=20>

  15. #15
    Lounger
    Join Date
    Jan 2001
    Location
    Tucson, Arizona, USA
    Posts
    45
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: File Opening Problem (Excel 97 SR-2)

    Well, that seems doubtful to me since I created the spreadsheet, nobody else has ever used it, and I know nothing about Excel addins. But, I gave it a try anyway. <img src=/S/nope.gif border=0 alt=nope width=15 height=15> Same results as before I changed the extension: I entered the password, but the file won't open.

    Thanks for the idea, though.

Page 1 of 2 12 LastLast

Posting Permissions

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