Question: how to copy excel sheet of one file to another excel file keeping formula working?
Answer: Open the source and the target workbook. ... , In the source workbook, navigate to the sheet you want to copy or move., Click the Home tab and then click the Format dropdown in the Cells group.