Pivot table in hidden sheet
 

I need to create a pivot table in a hidden sheet and the data from that
pivot table is pulled into another sheet..

I get Error 400 if the sheet is hidden..

Right now, I have made the sheet visible before the pivot table is
created and hid it after creation..I dont want the user to see the
sheet being unhidden and then hid..

Is there any other way?