Forum Discussion
Copy one excel sheet with formula to another workbook (Excel sheet)
Hi Guys, I have a excel file where 3 sheets have data and 4th sheet (Formula Functional sheet) have various formula, 4th sheet take references from initial 3 sheets. Now I have moved these 4...
Thanks a lot.
NKSNagendra7871 as long as the tab names are the same in the new file as they are in the original file, go to the Data tab in the new file and select Edit Links in the Queries & Connections section.
When the pop-up box appears, select the option to Change Source... and then select the new file as the source file. You will need to have saved the new file to be able to do this.