hello
i have a main page that get values from multiple sheet
when i create the link the result is this one:
'[3600 Cir. Água Ácida.xls]P-36110-1-1,5" BC'!$B$6
but when i close the file and open again the result is this:
C:\Users\Ricardo\Desktop\gestão vida equipamento\GERM - Gestão Equipamento Refinaria Matosinhos\FCO\Linha II\3600\[3600 Cir. Água Ácida.xls]P-36110-1-1,5" BC'!$B$6
it ads the entire direction.
the problem is when i want to transfer to another PC the main folder that contanins all the subfolders and files, the direction of update it will be wrong.
i want the update only moves inside the main folder and subfolders.
it can be done?
Bookmarks