View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chris M.[_3_] Chris M.[_3_] is offline
external usenet poster
 
Posts: 15
Default Copying into new spreadsheet

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.