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

JohnnyHK · May 6th, 2002, 09:33 PM

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

Nimrod · May 6th, 2002, 09:42 PM

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.

JohnnyHK · May 6th, 2002, 10:12 PM

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

Nimrod · May 6th, 2002, 10:18 PM

my pleasure..cheers

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 6th, 2002, 09:33 PM	#1
JohnnyHK New Member Join Date: May 2002 Posts: 2	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

May 6th, 2002, 09:42 PM	#2
Nimrod MrExcel MVP Join Date: Apr 2002 Location: Vancouver BC , Canada Posts: 6,259	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.

May 6th, 2002, 10:12 PM	#3
JohnnyHK New Member Join Date: May 2002 Posts: 2	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

May 6th, 2002, 10:18 PM	#4
Nimrod MrExcel MVP Join Date: Apr 2002 Location: Vancouver BC , Canada Posts: 6,259	my pleasure..cheers