Hi davecoop1
You can only copy and paste from the fully unlocked version of the spreadsheet which you need to purchase as explained on the download page
LINK
...the free version of the spreadsheet serves as a 'proof of concept' sufficient enough to help you make a decision as to whether you would like to purchase the commercial version.
Payment Processing
The unlocked dashboard spreadsheet and an invoice will be sent to your email account once the payment has been manually verified. Please note that depending upon the timezone this process may take between 12 to 24 hours to complete.
Commercial License Terms
The commercial license is based on 'fair use'. It allows the license holder, or any individuals within the license holder's organization, to use the Excel widgets in any way, shape, or form they choose. The commercial license allows the Excel widgets to be emailed to third party individuals outside of the organization but does not allow third party organizations to extract the widgets and uses them for their own purposes. This exceeds the 'fair use' terms and they must purchase their own separate 39 USD$ commercial license for their organization.
Hope this helps you make a decision and feel free to get in touch if you require further support.
Regards
DashboardWidgets