At this moment I am working on Excel automation using UiPath, my requirement is to copy an entire excel sheet between two excel files, the process works well but I have some cells that contain formulas and this formula references the source excel file. Is there any solution to copy the formulas updating the formula to reference the destination file?
while copying to source file , you can use hot keys like
+V -----Paste only the values (not the formulas).
+F------- Paste only the formulas as entered in the formula bar.
+R------Paste only formulas and number formats from copied cells.