Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 2
Default Hyperlink error only in template file

I'm facing a problem that I can't resolve.

I create two Excel file: A.xls and B.xls
In a cell of A.xls I put a link to name CELLB defined in B.xls
In a cell of B.xls I put a link to name CELLA defined in A.xls.
Then in A.xls I put a link on the first sheet to a cell named CELLNDFOLDER
in the 2nd sheet.
All work fine and I can switch between the two file and between the 2 sheet
of A.

Now I save the A.xls as A.xlt: I must open it and create each time a
new file. An xlt I think that can be the solution.

Now there are 2 problem:
1) the link in A.xlt (when I clic and open it it became A1.xls) that
link file B.xls give me an error "Site address not valid" (this is the
translation from Italian message)
2) the link in B.xls open the old A.xls, not the currently A1 open
file where is defined the name CELLA

If I put on Properties of A.xlt the current directory where A and B are, I
can go from A1 to B but I can't go from sheet1 of A to sheet 2 of A and I
can't go from B to A (that now is A1).

I can't save A1 with a name before that user has confirmed the data inserted.

Where I'm wrong?
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
Hyperlink to url returns error: cannot open the specified file browniebodrum Excel Discussion (Misc queries) 7 May 18th 23 11:45 AM
Hyperlink error in XLT file AndreaT Links and Linking in Excel 1 February 18th 09 11:31 PM
List - Hyperlink - Template - Email SteveT Excel Discussion (Misc queries) 2 June 17th 08 05:52 PM
Hyperlink to a template Murray Excel Discussion (Misc queries) 1 June 10th 05 01:29 PM
hyperlink error: "Cannot open the specified file" Kate Choi Excel Worksheet Functions 1 January 18th 05 02:38 AM


All times are GMT +1. The time now is 06:30 AM.

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

About Us

"It's about Microsoft Excel"