Notes: (1) If you cant switch to the destination workbook, please enter the destination address such as Book1Sheet1H2 into the above dialog box. excel formula sum from different worksheetsĮxcel For Mac Formulas Not Working From Different Worksheetsįull feature free trial 30-day, no credit card required Get It Now Copy formulas from one workbook to another without link by Auto Text Sometimes, you may just want to copy and save a complex formula in current workbook, and paste it to other workbooks in future.