I have started an index with Hyperlinking (using Excel) of many files that I need to interact and keep track of. My question is: When I click a link, the index Excel file closes and the link opens. Is it possible to keep the index Excel file open while the new file opens?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!
Hyperlinking in Excel
- Thread starter hobie17
- Start date
function, but my index workbook stays conveniently open. There must be something unexpected going on at your system... Regards, Me too!
I tried external fixed links, network links and local hard drive. The original sheet stays open but I need to find it through the "Window" menu. [The http links open in IE of course]
IE and Explorer each have a setting which allows you to select whether to always use a new window or close the original window or customize. Maybe ther's a similar setting in Excel. I just didn't find it yet.
![[smile]](/data/assets/smilies/smile.gif "[smile] [smile]")
I tried external fixed links, network links and local hard drive. The original sheet stays open but I need to find it through the "Window" menu. [The http links open in IE of course]
IE and Explorer each have a setting which allows you to select whether to always use a new window or close the original window or customize. Maybe ther's a similar setting in Excel. I just didn't find it yet.
It's the same story here - Excel stays open after I click on a link.
I'm using a sorted spreadsheet to keep track of PDF files which I can access through links in the spreadsheet. When Excel opens these files instead of showing the name of the file in the heading bar of the Adobe Acrobat window it says embedded file. This could be caused by Acrobat as easily as by Excel, but it is annoying not being able to see the name of the file I have open. The name is available when I go to save a copy of the file BTW. Just an annoying feature really, any solution would be welcome.
I'm using a sorted spreadsheet to keep track of PDF files which I can access through links in the spreadsheet. When Excel opens these files instead of showing the name of the file in the heading bar of the Adobe Acrobat window it says embedded file. This could be caused by Acrobat as easily as by Excel, but it is annoying not being able to see the name of the file I have open. The name is available when I go to save a copy of the file BTW. Just an annoying feature really, any solution would be welcome.
- Status