Hi,
I'm currently working on a Dashboard that is made available to the users through SharePoint 2010.
I would like for the users to be able to change currency on the Dashboard so i have come up with a fairly simple solution where the users select currency from a Data Validation drop-down list.
However, the problem is that Data Validation is not supported by Excel in the browser.
Is there any alternative to using Data Validation - which also works when opened in the browser through SharePoint? My initial thought was to use Slicers somehow - but I don't think that's possible.
You can find my sample file here.
I'm currently working on a Dashboard that is made available to the users through SharePoint 2010.
I would like for the users to be able to change currency on the Dashboard so i have come up with a fairly simple solution where the users select currency from a Data Validation drop-down list.
However, the problem is that Data Validation is not supported by Excel in the browser.
Is there any alternative to using Data Validation - which also works when opened in the browser through SharePoint? My initial thought was to use Slicers somehow - but I don't think that's possible.
You can find my sample file here.
