A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
I haven't used that functionality so can't answer your question. My original post identified that, as often as not, Copy would throw up an error message.
Things are a lot better now, since if you get the error message you can Cancel it and repeat the Copy. It then works. Maybe one day they'll get rid of the error completely.