Paste the copied link and leave the Replace field blank.Press Ctrl + h for opening the replace dialogue box.Make sure that the exact same sheet as the source sheet also exists in your current workbook.Copy the link, shown with the square brackets inside the formula.Find a cell relating to another workbook within a formula.If you want to avoid that the formulas are removed you might want to try another (more manual) approach: Using the replace function in Excel to replace the links with nothing: Please be careful: all cells referring to other workbooks within formulas will be changed to values. Any additional text from the Excel data source will be truncated. Note: Text fields in PowerPoint can contain up to 255 characters. Search Conditional Formatting rules to see if any of them are conidtional and cells in external files. Simply click the To Existing Chart button from the Charts menu in Excel’s think-cell toolbar and click on the chart in PowerPoint that you wish to link to. Search Data Validation rules for every cell to see if any of them are sourced from a list in an external file. Search Range Names for ranges in external files.
Usually, “normal” workbook links within formulas can be cut easily with the ‘Edit Links’ function included in Excel (the numbers are corresponding with the picture on the right hand side):
