Hi all,

I have a table in spreadsheet 1 where one of the column is hidden and accessible only by a password-protected macro. This table in spreadsheet 1 works fine, but it also feeds a pivot table in spreadsheet 2. Problem is that the confidential column in spreadsheet 1 can now be viewed by anyone if they use spreadsheet 2 because pivot tables requirements are such that you must select an entire set of cells and can't omit specific columns intentionally.

Is there a way to keep that confidential column hidden when using the pivot?


Thanks for your help.