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
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