Paste Match destination option greyed out in excel 2016 , but avilable in excel 2010
Paste match destination option is available in excel 2010 and not in 2016 . This option had been greyed out in excel 2016 . Due to lack of this option, the data can't be copied from one excel workbook to another workbook in the required format as the instances created are distinct. ( i.e. The numbers are copied in "text format" rather than number format.) Paste destination option can eliminate the above issue and get the date copied in the required format by the user.
Agreed, FRUSTRATING! I need it to do so, is there a way around this yet in Excel 2016? The paste values function DOES NOT WORK for various reasons, but when I use "paste special --> Values" I'm still having to convert the data to numbers, and then convert another column to dates. With 20,000 lines of data this takes FOREVER! There needs to be a fix :(