i found a way to get your pivot table into excel. Right click on pivot table and print frame in mac, you can then print to pdf and using online converters convert pdf to excel. A total pain, but still better than manually recopying all the data.

Yes, just unlocked this feature. I agree it serves very little purpose if you can extract the entire database out of the embedded block. The reason I requested it to start with is that I was trying to build personalised UI for my team. Even this is a...