data table: problem update links to excel sheet

[marcof]

I am using swx 2013 sp5 and excel 2007.

in this period I am making data tables whose values are convenient to be taken from a series of excel sheets with the function "link copy"
I found this problem, which I had met in the past and circled brutally not using the "link copy" function:
when the data table and the excel sheet are open at the same time if I turn the columns connected to the data table they are updated on the data table as it was an absolute link.
on the contrary, if I close the data table and in the sheet I choose the linked columns, when I reopen the data table the references remain to the previous columns. I don't need to tell you what kind of inexorable mess can happen.

is someone aware of a possible solution to prevent the connection being lost? I attach two images for more clarity, excel and swx files for those who want to do tests. I have no idea whether it depends on the old version of excel, swx or both.

Thank you.

 

[MassiVonWeizen]

What a beautiful bitch you came out of the cylinder:

I've been dismaying for a while to try to solve it with excel's functions.
the solution is to use a function that searches for column d1 and return the corresponding value.
the forum is as follows:
=cerca.orizz("d1"; '[prova link.xlsx](ref.riga()-1))

the variable (ref.riga()-1) returns the value corresponding to the current line and serves to copy the formula in the next rows without having to manually edit the reference; the -1 must be put because the search for the value d1 excludes the header. .

 

[marcof]

What a beautiful bitch you came out of the cylinder:

It's just that I'm seeing very little, so when I get back, I try to give the best

I've been dismaying for a while to try to solve it with excel's functions.
the solution is to use a function that searches for column d1 and return the corresponding value.
the forum is as follows:
=cerca.orizz("d1"; '[prova link.xlsx](ref.riga()-1))

the variable (ref.riga()-1) returns the value corresponding to the current line and serves to copy the formula in the next rows without having to manually edit the reference; the -1 must be put because the search for the value d1 excludes the header. .

Thank you so much!
I confess that to reading what comes after the symbol of = I had a missing o_o
madonna more or madonna less, if you could tie me the excel file of what you did, possibly with a copy of the data table seen who I have 2013 and I couldn't open your swx file) you would make me not little easier things

tomorrow I try to see if, with my very modest knowledge of these functions, I can conclude something good.

for the women you pulled I can try to get you to say a couple of repairing, three-fold expandable crops if you put me the excel file.

 

[MassiVonWeizen]

I also make this effort just because you have accumulated a lot of positive karma in the past years and I have benefited from your posts

in the annex you can find 3 files:
the file test linka file with the content to be copied in solid and that will refer to the address of your file test link in your folder location
a file that instead refers to the fiile test link contained in the attached folder on which you can experiment to verify that everything works

for the women you pulled I can try to get you to say a couple of repairing, three-fold expandable crops if you put me the excel file.

I prefer if you drink a good glass or a good beer to my health

 

[marcof]

drink a good glass or a good beer to my health

Consider it done!

Thanks again, I'll let you know.

 

[MassiVonWeizen]

@marcof, does the magheggio work?

 

[marcof]

@marcof, does the magheggio work?

causes of crowned force I suspended all the acrocco because that had to make me laser marking from those files at this time keeps closed and I have devoted myself to other. But now that I am really confined, if the needs of the dog will leave me a little tregua I look at you and let you know.
Anyway thank you and the bottle of wine to your health has already been drunk.

 

[marcof]

@marcof, does the magheggio work?

I tried now and works perfectly by moving the table anywhere within the selected cells as a range in the function. I just need to organize excel sheets of data origin by coloring the columns or identifying them somehow to remind me that they are connected to the data table and that I do not need to rename the column header.
Oh, they will also be bizarre, but for one like me this is very high-level programmezine, comparable to the creation of an algorithm that simulses human consciousness and writes of philosophy

 

[MassiVonWeizen]

Good. I'll escort good karma myself then.
prosit