I have nine workbooks I have combined into one workbook using the
drag-and-drop system as described by Bernard Liengme on 11/25/07. All the
workbooks were single worksheet's that my company uses as forms for personnel
files. I don't want to reinvent the wheel, but I am trying to make some of
the work easier.

What I am doing is setting up all the worksheets to autofill the redundant
information on each sheet, i.e. name, address, phone number, etc. I am using
the formula "=sheet!cell". It is working on some sheets and on others is
does not. On some of the sheets, only certain cells won't accept the formula
while others work just fine.

So, my question is: are some of the cells protected on a different level
than the usual sheet protection and locks (under formatting), and if so,
where do I view that information?