Refresh on MS Excel fails

Problem:

MS Excel shows data protection error when we click on "Refresh All" link.

When you click on "OK" you will see below error.

Solution:

You are receiving this error because your Excel sheet is in Protected Mode.

When the worksheet is protected, all cells are locked by default, which means that they cannot be edited.

You need to Unprotect worksheet by clicking "Unprotect" link from File>>Info Tab In MS Excel 2010.

After removing protection, you can Refresh Data through "Refresh All" link.

Also, Refer:
How to Use QODBC with MS Excel 2007
Using QuickBooks Data with Excel 2013 32-bit
How to Configure QODBC to Work With 64-bit MS Excel