Hi Edd
Sorry that you are having trouble opening the file. We just checked the download and it seems to be fine - what version of Excel are you using? We are using Excel 2010. Are you downloading the file from the following link?
The video we prepared which shows copying and pasting of widgets is actually a tutorial for users of the commercial version of the dashboard spreadsheet that is completely unlocked. The idea with the free version of the dashboard is that it is a "proof of concept" sufficient enough to help you make a decision as to whether you would like to purchase the commercial version. Unfortunately, we needed to protect parts of our intellectual property and as a result some parts of the free version of the Excel dashboard spreadsheet are locked.
In it's current from the free version of the dashboard spreadsheet shows random values every time you press F9 to refresh. Adding the activation code to the cell M13 of the 'Dashboard Configuration' Tab unlocks the cells on the page and allows you to fill in your own values for up to eight dials and four thermometers.
Hope this helps and please do get in touch via the forum with any assistance that you require with your dashboard.
Cheers
DashboardWiddgets