Register
Log In
Unanswered
Home
Dashboards
December 14, 2016
Offline
Greetings,
I have uploaded a dashboard report to Onedrive and the unlocked cells are interactive, however the slicers are not.
Two slicers - one to select months and one for years. Is there a way to retain the functionality of the slicers?
Thanks,
Frank Panipinto
July 16, 2010
Offline
Hi Frank,
Are the PivotTables that the Slicers are filtering in cells that are unlocked?
Mynda
Dashboards
December 14, 2016
Offline
Good question. Are you saying the actual pivot tables on a very hidden worksheet need to be editable?
July 16, 2010
Offline
Yes, because when you choose an item in the Slicer it changes the PivotTable so if the PivotTable can't change it won't work.
Dashboards
December 14, 2016
Offline
I unprotected the dashboard sheet and the entire pivot table sheet, and uploaded it.
I can select everything except the slicers. At a loss....I am using Excel 2016.
November 8, 2013
Offline
You mean that the Slicers itself are protected and you cannot make any selections? If so, right click the slicers, click on Size and Properties , and in Properties section make sure the Locked checkbox is not checked.
Dashboards
December 14, 2016
Offline
Not only not checked, but I unprotected all sheets and uploaded again, still no interaction.
Can I delete the online workbook and resend it without generating another .htm?
Do you think that would help?
November 8, 2013
Offline
Can you share a link to your online workbook?
Dashboards
December 14, 2016
Offline
Sure. How do I do that?
November 8, 2013
Offline
Right click the file on onedrive, and select Share.
Dashboards
December 14, 2016
Offline
https://1drv.ms/x/s!ApzuUcjvJDsBhhe9E4oyp6EDm9x5
Select your user name password is C_B
November 8, 2013
Offline
Hi Frank,
There is nothing wrong with the file, the slicers are functional, online and offline.
Try to repair your office installation, might be a corrupted installation. But if there is a problem with office installation, this should affect only the offline use, online you should be able to use the slicers without problems. Try with Internet explorer, or another browser, even if it should work fine with most browsers.
Dashboards
December 14, 2016
Offline
I have tried it with Edge, Chrome, Firefox, and Opera and none of them will let me select the slicer buttons.
It works perfectly on my Toshiba laptop with Excel 2016. I just tried hiding the data and pivot sheets again
and save the file with a different suffix. Then I altered the .htm file accordingly. It loads and displays the correct
file, but still no joy. Should I try rebuilding the htm file from scratch?
Dashboards
December 14, 2016
Offline
Update. If I click on the shared link I sent to you, I can select the slicer buttons, but cannot select any users, so the data does not display.
November 8, 2013
Offline
First, you have to click the button to "Edit in Browser". The workbook is not in edit mode by default, you have 2 choices: to edit in excel or in browser.
When creating the embed code, you have a few choices that should be selected: expand advanced options, and in Interaction section, yo have to select the option to "Let users sort and filter", and "Let people type into cells". The last one will not allow you to type a password or select from a dropdown if it's not enabled.
All setings are described here: interactive-excel-web-app-dashboard
Most Users Ever Online: 57
Currently Online: Meyanui
16 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Akshatraj Adig
Liesie Marais
Moet Lewis
Michelle Anderson
Veronica Gallego
krishnaraj r
Dharan Prakash Mishra
Md. Rahman
Lilian Vo
Jane Kumwenda
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
