MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Hyperlink closes original spreadsheet without saving

Posted by Chris on December 03, 2001 2:21 PM

Hi all,

sometimes when I add a hyperlink, when I click on it, it opens the required location but automatically closes the original spreadsheet without any prompt of save yes/no

Has anyone else seen this problem ? Or know what I'm doing wrong ?


Posted by JC on December 03, 2001 4:15 PM

That bothered me for the longest time too. In the 1st open .xls file, if a field changes (say just inserting anything anywhere, then your working within the .xls file and click on a hyperlink, your 1st open .xls file will stay open. It's when there has been no change in the original .xls file that it will close it.

Not the proper fix but a simple way around it that I found to help but just simply entering like "x" in any blank field to keep my main .xls list open so that I can ALT TAB back & forth

Posted by Chris on December 05, 2001 5:56 AM

Ahhhh, yes, that would make sense now !

thanks for the tip JC


Posted by Steve W on June 2, 2005

Here are 3 lines of code that should eliminate that problem. I know this is simple, but it took me a while to figure out a solution. Hopefully it can save someone else some time. Sub Auto_Open()
ThisWorkbook.Sheets(1).Range("z1").Value = Now()
End Sub