Special Pasting a work book with many sheets and formulas

  • Thread starter Thread starter lex63
  • Start date Start date
L

lex63

I have a workbook with many sheets that all have formulas and links to other
data. I want to save the workbook as another name with all the worksheets
keeping the values only (no links or formulas). Is there a quick way to do
this for everysheet without having to special paste every sheet in the
workbook. So can I save everysheets data values at workbook level.
 
Back
Top