How can I do this? Solved by S. You may want to check for and remove any of these types of links. Select the cell that contains the formula. Manually update all of the links or excel in updating not cells Linked of the links in a workbook Close all workbooks. Learn more about Allen But we can create a link between two worksheets or workbooks to automatically update data in another sheet if it changes in the first worksheet. Save your work.