Hello Everyone,
I am working with a very large master file (100MB) and a dashboard front (45MB). I have built a authentication login page using VBA code and have linked all Pivot tables (on hidden tabs) to be connected to our master data source.
The way the dashboard works on slicing these pivot tables to show different views and report options. Unfortunately the slicer is not picking up everything and is giving random data such as Mark becomes Mark2 or some names in the slicer do not show up although they are in the master data source and the pivot data source.
I am hoping someone has a fix for this slicer error. I have searched the forum and have not found any errors pertaining to this.
My question is: How to have the slicer option include all data in pivot data sources.
Any help is greatly appreciated.
Thanks!
Jag
I am working with a very large master file (100MB) and a dashboard front (45MB). I have built a authentication login page using VBA code and have linked all Pivot tables (on hidden tabs) to be connected to our master data source.
The way the dashboard works on slicing these pivot tables to show different views and report options. Unfortunately the slicer is not picking up everything and is giving random data such as Mark becomes Mark2 or some names in the slicer do not show up although they are in the master data source and the pivot data source.
I am hoping someone has a fix for this slicer error. I have searched the forum and have not found any errors pertaining to this.
My question is: How to have the slicer option include all data in pivot data sources.
Any help is greatly appreciated.
Thanks!
Jag