View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
monir
 
Posts: n/a
Default Link Protected WorkBook ... and Get #N/A for Text Values!

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