I have a Dynamic Chart. But Locking the data sheet prevents the Chart from working.

[Kingkoopa]

Hi Guys,

Currently using windows 7 and Excel 2010.

I have 3 excel sheets.

In the first sheet it contains my charts. In the 2nd sheet are where all my chart data's are. And the third sheet are all my source data.

Depending on the option selected in the chart the 2nd sheet data would change dynamically by retrieving the information from the third sheet.

So I tried locking the 2nd and 3rd sheet data to prevent others from messing around with it. However once I lock it. The chart no longer works it say the cell or chart you are trying to change is protected.

Seems like if I protect the sheet, the data in the protected sheet are not allowed to change?

Any work a round to this ?

Thank you

 

[RoryA]

You could hide the sheet instead of protecting it. If you use the VB Editor, you can set the sheet's visible property to xlsheetveryhidden so that it can't be unhidden through the Excel interface.