Hello;

Sheet1, Book1.xls contains text and numerical values. Sheet1 is hidden.
Book2.xls is linked to Book1.xls (Sheet1).
Open Book2, click Update, and ALL values are updated correctly.
Now, protect Book1. Open Book2, Update, and the numerical values are updated
correctly, but SOME of the text values are updated as #N/A.
Remove Book1 protection, and ALL text and numerical values are updated
correctly in Book2.

Does the above make sense to anyone?

I would very much appreciate your insight into the possible cause.

Thank you kindly.

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

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

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

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

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