title: An update values box appears when I use Paste.Special
body: <p>I open a file and select a worksheet.  I have material in the copy buffer to paste to it.  The next line does a PasteSpecial to that worksheet but a window pops up to update values with a list of filenames to select from.</p>
  
  <p>The second PasteSpecial call is okay.  The input window's title at the top says
  UPDATE VALUES: Ad Spreadsheet Variant.xslx -  which is a version of the workbook created and deleted a week ago.  </p>
  
  <p>I went to the data window and removed any dependencies listed in the connections panel so there are no connections.  I have stepped through the code with msgbox calls to see if the error is really not associated with the line of code but comes from somewhere else - but it always happens on that line.</p>
  
  <p>If I click on open in the update values box, nothing happens.</p>
  
  <p>If I click on cancel, the macro continues without error.</p>
  
  <p>I call only one subroutine in this module which checks whether the output file is already open.  I get the same problem in three other modules constructed the same way.  I know everybody hates 'activate' but I'm a beginner (in deep water) and I do what I can.</p>
  
  <p>I line up my input and output files, opened previously - I am just making sure they're accessible. It's not in a loop so the 'activate' time hit is of no concern.</p>
  
  <pre><code>Option Explicit
  
  Workbooks(Infilename).Activate
  Worksheets(InputSheet).Activate
  'I pickup the columns to copy
  
  Columns("B:AO").Select
  Selection.Copy
  
  'make sure the output file is lined up
  Workbooks(Outfilename).Activate
  Worksheets(TargetSheet).Activate
  
  Selection.PasteSpecial Paste:=xlPasteAllUsingSourceTheme, 
  Operation:=xlNone, _
    SkipBlanks:=False, Transpose:=False
  Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
      :=False, Transpose:=False
  </code></pre>
  
  <p>The results of this are fine except for this hiccup associated with the first <code>Selection.PasteSpecial</code> call.</p>
  
  <p>Image of the dialog box that appears</p>
  
  <p><a href="https://i.stack.imgur.com/TR7ZW.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/TR7ZW.png" alt="enter image description here"></a></p>