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