Copying into new spreadsheet

[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.

 

[EZ Money]

Select and copy all the data. Create a new workbook and in a blan worksheet
Edit>Paste Special>Values.