I have a macro that copies a pivot table to clipboard and then pastes it onto a spreadsheet. For couple of the users all works well and the formating of the table is correct, but for some users it goes wrong and the formatting is totally incorrect.
I have made sure all the user preferences are the same and everything is correct. Can anyone point me in the right direction.
Thanks in advance