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
EditPaste SpecialValues.

--
Greeting from the Gulf Coast!
http://myweb.cableone.net/twodays
"Chris M." wrote in message
...
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.