issues with password protected worksheets that are referenced
Posted on 2011-09-27
We have a user that has been having issues with Excel 2007 on Windows 7. It has been crashing with the sheets she is working with. We gave her a new machine with nothing installed but Office and still have the same issues.
So we have upgraded her to Office 2010, but now have a new issue. When she opens Excel workbook (2003 file type .xls) the referenced cells will not work properly. Instead it says #REF!
In Excel 2007 by default it will not update the workbook links, and gives you the option to update them. In Excel 2010 however even though it still gives you the option to update the links or not, I will still get the #REF! error even if I leave them disabled.
How can I correct this?