Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: Excel files opens but worksheet(s) are not visible

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have a large spreadsheet that was saved last Friday. Now when I atempt to open the file, the progress bar across the bottom gets about halfway done and then stops. The filename is diplayed at the top but there are no visible worksheets. Nothing is hidden and I don't have any macros stored in this workbook. Am I hosed?

  2. #2
    Board Regular George J's Avatar
    Join Date
    Feb 2002
    Location
    Edinburgh, Bonnie Scotland
    Posts
    957
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Ensure that you only have excel running if this is a large spreadsheet, if it still hangs does CTRL ALT DEL say that excel is not responding?

    If you are low on memory, try deleting your temp. internet files to free up some space.

    Good luck
    George J

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Now I am getting the error "Cannot find file...(or one of its components). Make sure the path and filename are correct and that allrequired libraries are avialible."
    Any ideas?

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    are you opening it from "start / documents" or from the recently used file list, also even from your "favourites" ?

    if so, it may have been moved and it can't be found...

    if you're opening via file, open and clicking then it's something more sinister, as you probably already suspected...


    :: Pharma Z - Family drugstore ::

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Ermm

    Any update..
    Are other Xls files effected.
    Email OK and word....

    Can yoy enail me this file to JackinthUK@hotmail.com

    I mighht have fun with this, and if has virus even more fun, love them!

    Thing something sill, can see virus,,,,
    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  6. #6
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    BTW

    Though.. best scan system regardless. latest update best aswell just in case..

    let me know
    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  7. #7
    New Member
    Join Date
    Mar 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks for your interest in my headaches.
    I'll give you a bit more detail on the problem...
    The file is size 15,707kb
    I can't open the folder by any means including from within Excel or just double clicking the file icon
    When I do attempt to open it, the progress meter at the bottom begins to move but about halfway through everything just dissapears and I'm left
    with the grey backgorund when Excel is open but no workbooks are open.
    I've tried opening the file while holding Shift key to make sure I didn't put a macro in the Workbook Open clause.
    I've come to the conclusion that I have somehow corrupted the data but we don't have any Excel recovery software on site so I can't tell for sure.

    I did scan for viruses and nothing else seems to be having problems.

    If you have further sugggestions please let me know.
    Thanks Again

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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