Access data in a closed workbook containing a protected worksheet

In a LinkedIn group, someone wanted to access data in a shared server-based workbook that contained a protected sheet with locked cells that were not selectable. In addition to sharing an automated way of doing this, this post contains two other embedded tips. The solution, as many know, is to enter a formula in the …

Continue reading ‘Access data in a closed workbook containing a protected worksheet’ »