As the title says hidden tables still show in the Excel pivot table drop down menu. I the box below the search box in Excel they do not show there however. I have searched around for an answer and only found one question on stackexchange regarding the issue, which was never answered (also the question was asked back in 2013). Any help would be much appreciated.