title: Excel VBA Error "The picture is too large and will be truncated" when closing file
body: <p>I have been working on this project for a long time and am suddenly getting a new error whenever I close my Excel file. I get the error twice "The picture is too large and will be truncated." There is no picture in my file. I am pasting formats.</p>
  
  <p>This seems to be one of the Excel "Unsolved Mysteries".</p>
  
  <p>I am using MS Office Professional Plus 2010 on Windows 7.</p>
  
  <p>I have researched this and tried the following:</p>
  
  <ol>
  <li>Deleted all %temp% files</li>
  <li>Ran CCleaner</li>
  <li>Set CutCopyMode =
  False after all paste special (formats)</li>
  <li>Went to add/remove
  programs and reconfigured Office to stop the Clip Organizer from
  running. (Control Panel\Programs\Programs and Features -> MS Office
  Professional Plus 2010 -> Change -> Add or Remove Features -> Office
  Shared Features -> Clip Organizer -> Not Available, etc.)</li>
  <li>Rebooted</li>
  </ol>
  
  <p>None of that helped, so I narrowed down the source of the problem by commenting out function and subroutine calls, running the program, saving and then pressing "x" to close. I did this until I found the right sub. Then I commented out all the lines of the sub and added them back in one logical chunk at a time until I found the problem area.  Here it is:</p>
  
  <pre><code>' *********** APPLY BASIC ROW FORMATTING FROM TEMPLATE ***********
  ' Copy basic row formatting from template and paste over all rows
  wksTemplate.Rows(giHEADER_ROW + 1).Copy
  myWS.Rows(lFirstRow &amp; ":" &amp; lLastRow).PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _
      SkipBlanks:=False, Transpose:=False
  Application.CutCopyMode = False
  </code></pre>
  
  <p>The paste contains formatting only - colors, borders, number formats, wrapping etc. It probably pastes on a range of 200 rows on average.
  I have not changed these 3 lines of code in months. Why now?</p>
  
  <p>Has anyone solved this mystery?</p>
  
  <p>Thanks,
  Shari</p>