hello
i have a main page that get values from multiple sheet
when i create the link the result is this one:
'[3600 Cir. 縵ua 繁ida.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緌 vida equipamento\GERM - Gest緌 Equipamento Refinaria Matosinhos\FCO\Linha II\3600\[3600 Cir. 縵ua 繁ida.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