Here is a cute trick for all of you ‘client’ jockeys out there. Sometimes you have a table that you, as a designer, have for some limited uses. Maybe the table exists for establishing relationships, or for intermediate calculations, but not for querying. How can you hide it? Well, it turns out that it is pretty easy to do although it is not intuitive. (Or it wasn’t to me as a server geek) You hide a table from the PowerPivot field list by hiding all fields from it in the PivotTable. In the PowerPivot window, go to the Design Tab | Hide & Unhide | Uncheck ‘Select All’ from the ‘In PivotTable’ column ). That is it, now the table won’t show in the field list (as there are columns to select).
Before you ask, you cannot hide a table from the PowerPivot window in V1. Sorry.
We had to save something for V2. 
Recent Comments