One Excel workbook is called as the source worksheet where this link carries the worksheet data automatically and the other workbook is called as the destination worksheet in which it automatically updates the worksheet data and contains the link formula. When the manual calculation mode is enabled you will need to press F9 on your keyboard to force formulas to recalculate. CTRLALTF9 force calculate open worksheets in all open workbooks including cells that have not been changed.
Just do the following steps.
One Excel workbook is called as the source worksheet where this link carries the worksheet data automatically and the other workbook is called as the destination worksheet in which it automatically updates the worksheet data and contains the link formula. SERIES Sheet1DateSheet1Temperature1 The chart will update automatically each day. And you can now recalculate the formula in the cell by double-click on the cell press Enter. Go to Sheet2 click in cell A1 and click on the drop-down arrow of Paste button on the Home tab and select Paste Link button.