A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Links and Linking
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Hyperlink error in XLT file



 
 
Thread Tools Display Modes
  #1  
Old January 22nd, 2009, 07:38 PM posted to microsoft.public.excel.links
AndreaT
external usenet poster
 
Posts: 1
Default Hyperlink error in XLT file

Hello to all.

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.

All work fine and I can switch between the two file.

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

Without any macro can I solve this problem?

--
Andrea Treggia
  #2  
Old February 19th, 2009, 12:31 AM posted to microsoft.public.excel.links
ids
external usenet poster
 
Posts: 1
Default Hyperlink error in XLT file


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:57 PM.


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