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

Thread: SO Basic!! Default saving and opening an excel file.

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

    Default

    Hi
    I have a problem which is very minor but is causing me a major headache. If anyone could help me with it I would be very grateful.

    I use Office ’97 (sorry no cash to upgrade) I use an Excel workbook in which there is set up over 200 individual hyperlinks to download data from a source on the net. Up until a short while ago, when I clicked on a hyperlink I was promted by a “File Download” box and presented with three options “OK, “Cancel” and “More info..” I would click “OK” and be presented with another box entitled “Save as” I could then enter a file name and click “Save”. Here’s where the problem begins. When I used to press “Save” it presented me with another box entitled “Download Complete” which asked me if I wanted to “open” the file or just “save” and close the file. For some reason Excel (now) automatically saves and closes the file and does not give me the option to open the file there and then. Because of this I have to find the file and open it manually. Doing this for 200 sets of data daily is incredibly boring.

    How can I restore the default version which gave me the option to open the file straight away? For info I have removed Excel from the computer and then reinstalled it but the same problem persists.

    Thank you in advance for your help
    JohnnyHK

  2. #2
    MrExcel MVP
    Join Date
    Apr 2002
    Location
    Vancouver BC , Canada
    Posts
    6,259
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    This is probably due to an option in you web browser and not excel. You may want to go into your WebBrowser Options and make sure : "Notify when downloads complete" has been enabled. Please note that the option your looking for will vary between browser versions.

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

    Default

    Nimrod
    You are the greatest! Thank you so much. I knew it was simple but I'd never have got there without your input.

    I'd like to return the favour but with my knowledge!! haha

    Thanks again mate and all the best

    JohnnHK

  4. #4
    MrExcel MVP
    Join Date
    Apr 2002
    Location
    Vancouver BC , Canada
    Posts
    6,259
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    my pleasure..cheers

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
  •