Hi all, im trying to run a macro to refresh a worksheet full of pivot tables to update all my graphs on a seperate worksheet. i want to hide the worksheet with the pivot tables on the the users cant see this, but when i run my macro it comes up with errors as the worksheet is hidden any ideas?