Sunday 31 August, 2008

Copy paste weirdness

Filed under: All things Excel

If I open two instances of Excel 2007 and copy a range from one to another using paste special, the destination doesn't recognise the copied range as an Excel object. Instead of offering paste values, paste formulas (it's formulae, goddamit), transpose and the like, it offers me Microsoft Office 2003 Worksheet Object, Picture (Enhanced Metafile), Bitmap etc. Copying between two workbooks within the same instance behaves correctly. Bizarre, and rather annoying.


Posted by dan at 9:10pm | Permalink | Comments (0) | Trackbacks (0)
Comments
Add comment (all comments are currently moderated)
Your name*
Enter the confirmation code* authimage
Comments *



* denotes a mandatory field