Linking to protected workbooks -- #N/A {Please help}
Posted by Jennifer on February 06, 2001 12:38 PM
I have an Excel file that summarizes the information in many other smaller Excel files. It gets the information through links and lately I am randomly getting #N/A errors. The only thing I have changed is that I protected the structure of the source workbooks. The #N/A errors only occur where a person has entered a character value in a specific cell (D41) in the source file, but the other linked values come through normal. Has anyone heard of problems regarding linking to protected workbooks (Tools->protection->protect workbook)? Any help would be greatly appreciated. Thanks!