C
cuyuni
Hi all,
I have a question for the forum.
If I have two workbooks, let’s say workbook1 (database) & workbook2
(calc’s)
Workbook1 has two spreadsheets named “tab1” & “tab2”.
Workbook2 has one spreadsheet named “calcs”.
Workbook2 has formulas linked to workbook1 which contains all the data
needed for the calculation.
My question: is there any way I can reference the formulas in
worksheet2 to the “internal” name of the tabs in worksheet1, so it
doesn’t matter if the names of the two spreadsheets change, the links
in spreadsheet2 still work ?
I don’t know if excel keep an internal name or index for each
spreadsheet instead of the name we put in the tabs.
I appreciate your help,
Thanks
I have a question for the forum.
If I have two workbooks, let’s say workbook1 (database) & workbook2
(calc’s)
Workbook1 has two spreadsheets named “tab1” & “tab2”.
Workbook2 has one spreadsheet named “calcs”.
Workbook2 has formulas linked to workbook1 which contains all the data
needed for the calculation.
My question: is there any way I can reference the formulas in
worksheet2 to the “internal” name of the tabs in worksheet1, so it
doesn’t matter if the names of the two spreadsheets change, the links
in spreadsheet2 still work ?
I don’t know if excel keep an internal name or index for each
spreadsheet instead of the name we put in the tabs.
I appreciate your help,
Thanks