I usually want to paste pivots without the underlying data, so I paste from the clipboard as this does a nice job of preserving the formatting. Now I noticed, seemingly randomly, that sometimes the formatting was lost and just the raw text was pasted. I persevered to investigate why some tables pasted ok and others were just text and eventually discovered that any copied data that consists of 36 or more rows looses its formatting when pasted. I can get around this by cutting and pasting the pivots by cutting 35 rows at a time and pasting them separately but thought theres got to be a better solution.
Bookmarks