I need to change the cells formulas to target a new internal worksheet.
I´ve tried to get a substring from the original formula and set it up in the cell (because the source worksheets have the same name) but the excel file turns in a corrupted file.
Is there a correct ways to do this?
PS: The source is on a network folder and need to be updated many times. We will copy it to a internal worksheet on the excel files to be able to update values on the sources without need to open the excel files to update the links.
I hope that’s clear enough.