My workbook, one of the sheet is protected and having all graph and a pivot table. Other sheets are not protected , but I am getting error while opening due to protection in that one sheet . It is trying to refresh while opening. Can someone help me having a VBA code to solve this when opening workbook Thanks