I ran die MS Office diagnostics which picked up one problem which it corrected. When I now use Paste Special...Text it works fine. But the cells must also be preformatted as text.