title: Excel after save as get #REF for formulas
body: <p>I need a macro that creates a duplicate workbook with all sheets (except for "Data List") and all macros/userforms. This is what I have so far:</p>
  
  <pre><code>fname = Application.GetSaveAsFilename(FileFilter:="Excel Files (*.xlsm), *.xlsm")
  ActiveWorkbook.SaveAs Filename:=fname, FileFormat:=52
  
  Application.DisplayAlerts = False
  Worksheets("Data List").Delete
  </code></pre>
  
  <p>The problem is, my formulas stop working since they refer back to "Data List". How can I solve this?</p>
  
  <p>Context/Edit:</p>
  
  <p>Sorry, my question was poorly worded. I forgot to include the fact that I was getting #REF errors because some formulas referred back to the original workbook, which has the "Data List" sheet. Previously, I copied all the sheets EXCEPT the "Data List" into a new workbook, and everything worked like a charm until I sent the file over to another person, and then all the macro's failed. So I'm in the process of finding a work around to this problem, hence saving the entire workbook and then deleting one worksheet. However, now my formulas are not working.</p>