Create Pivot Table in Hidden Sheet

Hi!

I'm getting a 1004 run-time error when creating a pivot table.

I believe this happens because I'm creating it in a hidden sheet. When I unhide it no errors occur.

Can anybody tell me if I'm correct? If so, how can I overpass this?

Thanks in advance!

Good morning pmguerra

Originally Posted by pmguerra

Can anybody tell me if I'm correct? If so, how can I overpass this?

You will need to unhide the sheet, create your pivot table, and then rehide the sheet again.

To prevent users from seeing the flicker as these things happen, try disabling the screen updating whilst it occurs :

Please Login or Register  to view this content.

HTH

DominicB