We have several final report sheets that obtain values from links to a master data sheet.
We copy and paste the values to break the links using the following VBA Code.
There must be a more efficient way remove links and formulas from an Excel Workbook.
in this example all of the hidden sheets are deleted later using VBA code.
If Sheets("ONE").Visible = True Then
If Sheets("TWO").Visible = True Then