Page 1 of 1

How to unprotect a sheet?

PostPosted:Thu Sep 18, 2014 3:11 pm
by boomer4208
I have purchased a commercial licence & need to remove all sheet protections so that I can deploy the widget to a SharePoint website using the Excel Services web part.

Where do I find the password(s) necessary to completely unlock each sheet?

Thank you

Re: How to unprotect a sheet?

PostPosted:Thu Sep 18, 2014 6:07 pm
by DashboardWidgets
Hi boomer4208

There are two pages in the spreadsheet.

Tab 1. The dashboard
Tab 2. The configuration page

If you register we supply an activation code which unlocks the configuration page so you can enter values in the boxes for the range and target values of the dials and thermometers.

There are a total of 8 dials and four thermometers. These can be moved around on the excel dashboard page into any geometric layout. They can also configured with different fonts, background and foreground colors and styles. Dashboard design logic generally states that there should be just enough information on the dashboard for the user to be able to make informed decisions (analagous to a vehicle dashboard - which tells you the speed you are moving at, if the vehicle is overheating, if have run out of gas). We are very happy to help you arrange your excel dashboard into something useful for your organization. If you need a spreadsheet with more thermometers or dashboards we can modify the spreadsheet for you.

We are very happy to help with your excel dashboard project. Feel free to upload a sketch or clear description to the forum and we are comitted to helping you produce a great product.

Cheers

ExcelDashboardWidgets

Thanks for support

PostPosted:Sat Sep 20, 2014 3:19 am
by boomer4208
Got your private message. Thanks for all the support, this is really useful.

Re: How to unprotect a sheet?

PostPosted:Wed Mar 25, 2015 1:54 am
by medrobert
Hello,

Just purchase "ExcelDashboard Widgets" would like to use them but the password will not unlock them, any suggestions?

Re: How to unprotect a sheet?

PostPosted:Wed Mar 25, 2015 9:02 pm
by DashboardWidgets
Hi MedRobert

You should have received an unlocked version of the excel spreadsheet by email yesterday.

Let us know if you have any problems or need further support with your excel dashboard project.

Regards

ExcelDashboardWidgets

Re: How to unprotect a sheet?

PostPosted:Sat Apr 18, 2015 9:33 pm
by jsoepnel
I've received the code, but the configuration sheet Excel (2007) won't unlock. Please help!

Re: How to unprotect a sheet?

PostPosted:Sun Apr 19, 2015 10:46 pm
by DashboardWidgets
Hi Jsoepnel

The unlock code allows you to enter your own data on the tab entitled "Example Dashboard Configuration Page". The simple example dashboard (traffic lights, thermometers, dials, etc.) will now work with your own data including target values and scale values.

The version we have supplied should be sufficient so that you can see all the features of the excel dashboard and you decide if this is useful for your organization's needs.

If you wish to purchase the full unlocked version of the spreadsheet you can purchase the commercial license here

Sorry for the confusion and hope this helps.

Good luck with your dashboard project.

DashboardWidgets

Re: How to unprotect a sheet?

PostPosted:Sun May 03, 2015 7:44 am
by valenciamc
Regestered but received no activation code. ??

Re: How to unprotect a sheet?

PostPosted:Sun May 03, 2015 8:17 am
by DashboardWidgets
Hi Valenciamc

Log into the forum and navigate back to the download page.

http://www.exceldashboardwidgets.com/phpBB3/download.php?nlang=en

The code appears automatically.

Let us know if you need further support.

DashboardWidgets