Here's a workaround. It solves the #N/A error in Book2.xls when the w/b is
linked to a protected Book1.xls.
It does not however shed any light onto the cause of the problem!
1. In Sheet1 Bookk1.xls, replace those text values (which produced #N/A in
Book2.xls) by referenced values.
2. For example, if cell C9 Sheet1 Book1.xls is one of those text cells and
has the value Test, then store Test in a different cell C10, and in cell C9
make reference to C10.
3. Hide the w/s. Protect & Save & Close the w/b.
4. Open Book2.xls and click Update. Now, all the text and numerical values
are updated correctly from the protected w/b Book1.xls.

I was a bit surprised that there were no takers among you experts! I
probably did not explain the problem clear enough.


"monir" wrote:

Open Book2.xls. click Update. Some text values are displayed as #N/A.

When I replace those text values in Sheet1 Book1.xls by numerical values and
again protect the w/b, the values are updated correctly in Book2.xls !!!

There's NO code, conditional formatting, events, etc. on Sheet1.

Could the problem be associated with memory ?

Thank you.

"monir" wrote:

Hello;
Here's another scenario:
Book1.xls: Sheet1 is hidden. w/b is protected.
Book2.xls: automatically linked to Book1. w/b is not protected.
NO cells or w/s are protected in either workbooks.
Open Book2.xls. click Update. Some text values are displayed as #N/A.
Now, open Book1.xls while Book2.xls is open. The #N/A are replaced by the
correct updated values !!!!!!

Does the above help in identifying the problem ??
Thank you.


"monir" wrote:

No cells are protected.


"mrice" wrote:


Could some of the cells be set to protected and others not?


--
mrice

Reserach Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=535318