Excel Hyperlinks closing original document

[rseiler]

I am having a little problem using hyperlinks in Excel.

What I am trying to do is create an Excel file with about 15 hyperlinks linked to various other (read only) Excel files. This spreadsheet is to act like a shortcut screen with a description as to what is being selecting.

The problem I am having is when I click a hyperlink it opens that file correctly but in the process closes the Excel file with the hyperlinks on it. I need to find a way to keep this file open so that the users doesn't have to reopen the file with the hyperlinks on it every time they click on a link.

Any suggestions will be greatly appreciated

Thanks
Rick Seiler

 

[flareman]

Just an idea! Is the file you are working on still called Book1.xls?
Before you work on the file, saveAs "a_new_name.xls". Then try again.

David

 

[rseiler]

flareman,
It has it's own name.

I should have mentioned this earlier, but sometimes the file will stay open (not very often). To me, it is random. I created all the hyperlinks the same way. It doesn't seem to matter which hyperlink I click on, they all will close the main file.

Thanks for the suggestion any more?,
Rick

 

[desireeg]

Rick:

I tested some hyperlinks in Excel and think I may have found a solution for you. You will have to get the hyperlink to create a new document, then replace that new document with the document you really want by renaming the old document.
- type in the text you want for the hyperlink
- highlite it, right click, choose hyperlink
- on the left, choose the "create new document" option
- type in a document name, (make sure the paths are right,) check the radio button the edit the new document later, click ok.
- follow your new hyperlink, type some junk in a cell, close the workbook and save it.
- then go to the correct folder, delete that newly created workbook, rename the workbook you really wanted to use with the same name of the workbook you just deleted.

I tested this a couple of times on W2k, Off2K. It opened two instances of Excel.

Hope this helps!
Desiree

 

[rseiler]

Desiree,

This didn't work for me. THANK YOU SO MUCH FOR TRYING!!

Not sure if this will matter but i am running Win NT with Office 97. I did however figure out how to allow the main file with all the hyperlinks to stay open. All I had to do was right click any hyperlink and choose "edit hyperlink" then close out of the edit screen (didn't make any changes). Now when i choose a link, the main file stayes open. This works as long as i keep the main file open. But as soon as i reopen the main file and click on a hyperlink it closes out.

Can anyone help??? I'm running out of ideas.

Rick

 

[bandit600]

Rick,

Sorry if I'm a bit late but I'm a newbie.

I've been looking at a similar problem for a friend who is having a problem opening hyperlinks to our intranet from Word 97.

I've found that there is a Microsoft knowledge base article on the subject, no 186140. It deals with Word 97 but I've seen elsewhere that it equally applies to Excel. The problem relates to whether the file with the hyperlink has been saved or not. An unsaved file does not close when you click on the hyperlink, but a saved (or re-opened) one does. Apparently the problem was fixed in Word 2000.

Two possibly solutions I've found may or may not work depending on the circumstances. The first should work if you have the web toolbar visible. All you have to do is click Back, your original file with the hyperlink should re-appear. The second only works for me intermittently, you need to toggle the field code by pressing Ctrl + F9. Then between the last " and the closing } insert \n. This forces the new page to be opened in a new window.

Hope this helps.

bandit600

 

[graphman]

Just jumping in ... if you don't have a work around yet;
In similiar instances, I use an auto-open macro that creates a change in the file on opening ... it has been my experience that hyperlinks will not close a file that has been changed. (i.e. onening have the macro put a character in an unused cell then delete it and move to location in file you want it on opening.)

The file will not close until you close it or run a macro that closes it.

 

[Dreamboat]

Seems to me it'd be just as easy to draw some textbox buttons and assign a macro that opens that file... Anne Troy

http://www.TheOfficeExperts.com

 

[dspear]

Just surfing around and I found the same problem at

http://216.239.39.100/search?q=cach...20115823.html+Excel+hyperlinks&hl=en&ie=UTF-8

with the response of:
See if this article resolves the problem:
Q156264 XL97: Document Disappears After Clicking Hyperlink

http://support.microsoft.com/support/kb/articles/q156/2/64.asp

I haven't checked this but maybe it helps.