Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 7th 05, 06:13 PM
Frustrated Engineer
 
Posts: n/a
Default Excel hyperlink to another Excel file

I created a hyperlink in A Excel file to B Excel file. It referenced a
bookmark in B. It worked when I tried it before I closed it and it worked.
When I opened A again and clicked the hyperlink, it said "The address of the
site is not valid...Check the address and try again."



  #2   Report Post  
Old April 7th 05, 08:45 PM
Carole O
 
Posts: n/a
Default

My guess would be that you need to open B Excel file, too

Carole O

"Frustrated Engineer" wrote:

I created a hyperlink in A Excel file to B Excel file. It referenced a
bookmark in B. It worked when I tried it before I closed it and it worked.
When I opened A again and clicked the hyperlink, it said "The address of the
site is not valid...Check the address and try again."


  #3   Report Post  
Old April 8th 05, 03:11 AM
Dave Peterson
 
Posts: n/a
Default

I'd guess you had a typo.

You may want to post the way you did the hyperlink (insert|link or
=hyperlink()???).

And what your hyperlink address was.

(Don't have any octothorpes (#) in the filename/sheetnames.)

Frustrated Engineer wrote:

I created a hyperlink in A Excel file to B Excel file. It referenced a
bookmark in B. It worked when I tried it before I closed it and it worked.
When I opened A again and clicked the hyperlink, it said "The address of the
site is not valid...Check the address and try again."


--

Dave Peterson
  #4   Report Post  
Old April 8th 05, 01:55 PM
Frustrated Engineer
 
Posts: n/a
Default

Dave & Carol,

Thank you both for the help, but it still doesn't work.

Here's what I have as the hyperlink within file A:

=HYPERLINK("[H:\\Battery Control Systems\Customer Programs\Standard Pack
DV\BMS DV Test Plan 30mar05.xls]BCM In-Out I&V!", "BCM In-Out I&V")

Anymore recommendations?



"Dave Peterson" wrote:

I'd guess you had a typo.

You may want to post the way you did the hyperlink (insert|link or
=hyperlink()???).

And what your hyperlink address was.

(Don't have any octothorpes (#) in the filename/sheetnames.)

Frustrated Engineer wrote:

I created a hyperlink in A Excel file to B Excel file. It referenced a
bookmark in B. It worked when I tried it before I closed it and it worked.
When I opened A again and clicked the hyperlink, it said "The address of the
site is not valid...Check the address and try again."


--

Dave Peterson


  #5   Report Post  
Old April 8th 05, 02:32 PM
Dave Peterson
 
Posts: n/a
Default

Why do you have two back slashes after the H: portion.

And both of these formats worked ok for me.

To just open the workbook:
=HYPERLINK("C:\My Documents\excel\book1.xls","whatever")

To go to a certain cell on a worksheet:
=HYPERLINK("C:\My Documents\excel\book1.xls#sheet3!d99","whatever")



Frustrated Engineer wrote:

Dave & Carol,

Thank you both for the help, but it still doesn't work.

Here's what I have as the hyperlink within file A:

=HYPERLINK("[H:\\Battery Control Systems\Customer Programs\Standard Pack
DV\BMS DV Test Plan 30mar05.xls]BCM In-Out I&V!", "BCM In-Out I&V")

Anymore recommendations?

"Dave Peterson" wrote:

I'd guess you had a typo.

You may want to post the way you did the hyperlink (insert|link or
=hyperlink()???).

And what your hyperlink address was.

(Don't have any octothorpes (#) in the filename/sheetnames.)

Frustrated Engineer wrote:

I created a hyperlink in A Excel file to B Excel file. It referenced a
bookmark in B. It worked when I tried it before I closed it and it worked.
When I opened A again and clicked the hyperlink, it said "The address of the
site is not valid...Check the address and try again."


--

Dave Peterson


--

Dave Peterson


  #6   Report Post  
Old April 8th 05, 02:47 PM
Frustrated Engineer
 
Posts: n/a
Default

I am going to try to put them on the same drive and resolve it that way.

Thanks again...

"Dave Peterson" wrote:

Why do you have two back slashes after the H: portion.

And both of these formats worked ok for me.

To just open the workbook:
=HYPERLINK("C:\My Documents\excel\book1.xls","whatever")

To go to a certain cell on a worksheet:
=HYPERLINK("C:\My Documents\excel\book1.xls#sheet3!d99","whatever")



Frustrated Engineer wrote:

Dave & Carol,

Thank you both for the help, but it still doesn't work.

Here's what I have as the hyperlink within file A:

=HYPERLINK("[H:\\Battery Control Systems\Customer Programs\Standard Pack
DV\BMS DV Test Plan 30mar05.xls]BCM In-Out I&V!", "BCM In-Out I&V")

Anymore recommendations?

"Dave Peterson" wrote:

I'd guess you had a typo.

You may want to post the way you did the hyperlink (insert|link or
=hyperlink()???).

And what your hyperlink address was.

(Don't have any octothorpes (#) in the filename/sheetnames.)

Frustrated Engineer wrote:

I created a hyperlink in A Excel file to B Excel file. It referenced a
bookmark in B. It worked when I tried it before I closed it and it worked.
When I opened A again and clicked the hyperlink, it said "The address of the
site is not valid...Check the address and try again."

--

Dave Peterson


--

Dave Peterson

  #7   Report Post  
Old April 8th 05, 02:56 PM
Dave Peterson
 
Posts: n/a
Default

I don't think that should matter.

Frustrated Engineer wrote:

I am going to try to put them on the same drive and resolve it that way.

Thanks again...

"Dave Peterson" wrote:

Why do you have two back slashes after the H: portion.

And both of these formats worked ok for me.

To just open the workbook:
=HYPERLINK("C:\My Documents\excel\book1.xls","whatever")

To go to a certain cell on a worksheet:
=HYPERLINK("C:\My Documents\excel\book1.xls#sheet3!d99","whatever")



Frustrated Engineer wrote:

Dave & Carol,

Thank you both for the help, but it still doesn't work.

Here's what I have as the hyperlink within file A:

=HYPERLINK("[H:\\Battery Control Systems\Customer Programs\Standard Pack
DV\BMS DV Test Plan 30mar05.xls]BCM In-Out I&V!", "BCM In-Out I&V")

Anymore recommendations?

"Dave Peterson" wrote:

I'd guess you had a typo.

You may want to post the way you did the hyperlink (insert|link or
=hyperlink()???).

And what your hyperlink address was.

(Don't have any octothorpes (#) in the filename/sheetnames.)

Frustrated Engineer wrote:

I created a hyperlink in A Excel file to B Excel file. It referenced a
bookmark in B. It worked when I tried it before I closed it and it worked.
When I opened A again and clicked the hyperlink, it said "The address of the
site is not valid...Check the address and try again."

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Large Excel file size caused by a bug ? I really tried everything Anik Excel Discussion (Misc queries) 5 March 16th 05 06:19 PM
2003 Excel isn't reading the book.xlt file on startup. rlweaver007 Excel Discussion (Misc queries) 1 March 15th 05 09:26 AM
save excel file from a table delimited file (.txt) using macros sedamfo New Users to Excel 1 February 15th 05 04:19 AM
Excel 2003 Opens Up Every File in My Documents Glenn Reschke Excel Discussion (Misc queries) 4 February 11th 05 06:00 PM
Using Jet to read excel file returns blank for last cell - sometim Ron Excel Discussion (Misc queries) 1 December 9th 04 08:21 AM


All times are GMT +1. The time now is 06:17 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017