Originally posted by soloken:
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.
No idea??