Copying into new spreadsheet

  • Thread starter Thread starter Chris M.
  • Start date Start date
C

Chris M.

I have a spreadsheet with several Vlookup references, and
would like to copy the entire workbook into a new
workbook, along with any formatting that has been done. I
do not want to copy formulas, only the values they create,
mainly because it causes 'update' error messages to be
displayed upon opening the spreasheet. Perhaps there's a
way to supress the message isntead? Either way works
great. Thanks in advance.
 
Select and copy all the data. Create a new workbook and in a blan worksheet
Edit>Paste Special>Values.
 
Back
Top