Hi All,

I'm working with Excel 2010 with a data connection to SQL Server 2008R2.

I have a requirement that users are not allowed to change data in a cell but the sheet itself should not be protected.
After some googling I found the answer, working with intersect and is nothing.
It works as it should.

Please Login or Register  to view this content.
Problem is that my data comes from an external source and when the workbook is opened, it automatically refreshes the data, as it should, and then it gives me an error telling me that the action is not allowed. Reason, the refresh of the data is considered as a change in the specified range.

Is there a way to open the workbook (or refresh the worksheet) without the worksheet_change to trigger?

Thank you.
Regards,
Vera