ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   hyperlink in Excel to Word doc closes Excel doc (https://www.excelbanter.com/excel-discussion-misc-queries/17965-hyperlink-excel-word-doc-closes-excel-doc.html)

Hyperlinks close Excel Document March 16th 05 07:55 PM

hyperlink in Excel to Word doc closes Excel doc
 
Clicking hyperlink to a word document in my Excel workbook work only once.
Every other time the excel document closes as the word document opens???

This is obviously annoying, because I want to go back and forth between my
multiple documents

Dave Peterson March 16th 05 09:25 PM

Are you using xl97?

If you are, try making a change to a cell (any change, any cell), then click the
hyperlink.

(Selecting a cell, hitting F2, then enter may be enough of a change.)

I think that if excel sees your workbook as "dirty" (needing a save), then it
won't close.

Hyperlinks close Excel Document wrote:

Clicking hyperlink to a word document in my Excel workbook work only once.
Every other time the excel document closes as the word document opens???

This is obviously annoying, because I want to go back and forth between my
multiple documents


--

Dave Peterson

Hyperlinks close Excel Document March 17th 05 02:13 AM

Yes. this seemed to work. Unsaved excel doc will stay up when a hyperlink to
a word doc is clicked. A fresh, or saved, excel doc will close. This is still
annoying, but I now know how to deal with this.

thanks.

"Dave Peterson" wrote:

Are you using xl97?

If you are, try making a change to a cell (any change, any cell), then click the
hyperlink.

(Selecting a cell, hitting F2, then enter may be enough of a change.)

I think that if excel sees your workbook as "dirty" (needing a save), then it
won't close.

Hyperlinks close Excel Document wrote:

Clicking hyperlink to a word document in my Excel workbook work only once.
Every other time the excel document closes as the word document opens???

This is obviously annoying, because I want to go back and forth between my
multiple documents


--

Dave Peterson



All times are GMT +1. The time now is 04:19 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
ExcelBanter.com