Hi,
I have the following issue:
I have one file in which there are many cells with sums of VLOOKUPS in other files (i.e. A1=VLOOKUP(FILE_1)+VLOOKUP(FILE_2)). This file is used to create monthly reports, so every month there is a new FILE_1 and FILE_2 with a new name and a new summary file with these sums and operations involving the new FILE_1 and FILE_2.
After doing this process for the first month, what I did for the following one was to copy the summary file, rename it and when I went to Data->Edit Links and selected the option to change the source of this FILE_1 to the new one from this month, it starts asking me, for EVERY cell in which there's a formula involving FILE_1 and any other file, to select the source for those files too. By this I mean that if I have 4 files, instead of changing the source for each one of them for the new one (4 changes) and that being valid for all the document, I have to do it for each cell, so if for example I have 10 cells with formulas involving those 4 files, I need to make 40 sources change. And I have dozens of formulas, not just 10!
So I wanted to know if there is some way to avoid this happening and just changing once each source or in general a smarter way to do this.
Thank you very much for your help.
I have the following issue:
I have one file in which there are many cells with sums of VLOOKUPS in other files (i.e. A1=VLOOKUP(FILE_1)+VLOOKUP(FILE_2)). This file is used to create monthly reports, so every month there is a new FILE_1 and FILE_2 with a new name and a new summary file with these sums and operations involving the new FILE_1 and FILE_2.
After doing this process for the first month, what I did for the following one was to copy the summary file, rename it and when I went to Data->Edit Links and selected the option to change the source of this FILE_1 to the new one from this month, it starts asking me, for EVERY cell in which there's a formula involving FILE_1 and any other file, to select the source for those files too. By this I mean that if I have 4 files, instead of changing the source for each one of them for the new one (4 changes) and that being valid for all the document, I have to do it for each cell, so if for example I have 10 cells with formulas involving those 4 files, I need to make 40 sources change. And I have dozens of formulas, not just 10!
So I wanted to know if there is some way to avoid this happening and just changing once each source or in general a smarter way to do this.
Thank you very much for your help.