Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.setup
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Hyperlink to url returns error: cannot open the specified file | Excel Discussion (Misc queries) | |||
Hyperlink error in XLT file | Links and Linking in Excel | |||
List - Hyperlink - Template - Email | Excel Discussion (Misc queries) | |||
Hyperlink to a template | Excel Discussion (Misc queries) | |||
hyperlink error: "Cannot open the specified file" | Excel Worksheet Functions |