Hi, hope somebody can enlighthen me:
I have a main excel files that sum up many excel files, but I have
a problem when I have an additional excel file, I need to change
the link in the main excel file which is very tiring, is that a
short cut?
For Example
The main sheet Cell A =Sheet BA1 + Sheet CA1 + Sheet DA1
But if I have sheet EA1, I have to change the cell formula in the
main sheet and the main sheet has many cell, which I have to change
every single link in the cell, is there a universal formula or
command that I change in main sheet Cell A, and all the cells in
the main sheet that contain the link will automatically add the
extra link, in this case become The main sheet Cell A =Sheet BA1 +
Sheet CA1 + Sheet DA1 + Sheet EA1??
Please advise.