G
Guest
Hi All,
I am developing an anomaly report for a range of users with different skill
sets etc. I have so far used excel as it is very important that some of the
infomraiton be locked away from well meaning meddlers and that the choices
people have are limited to a list of options to report on. (named items etc)
I understand how to do this in excel (using lookups etc and
locking/protecting various cells) is there a way to do it in word or is excel
the best option? I would like to use word if possible because people are
familiar with it and it is a much better reporting program - ie a word
processor! But limiting people's choices is really important for consistency
- there are too many people and it is too confusing to "make" people use a
consistent format by choice - they have to be forced to do so within the
report itself.
If the answer is "no" I'll continue using excel, but if it can be done,
could someone please point me in the right direction? I use word 97 (don't
ask) they use word 2000 (I think).
Thanks,
Fiona
I am developing an anomaly report for a range of users with different skill
sets etc. I have so far used excel as it is very important that some of the
infomraiton be locked away from well meaning meddlers and that the choices
people have are limited to a list of options to report on. (named items etc)
I understand how to do this in excel (using lookups etc and
locking/protecting various cells) is there a way to do it in word or is excel
the best option? I would like to use word if possible because people are
familiar with it and it is a much better reporting program - ie a word
processor! But limiting people's choices is really important for consistency
- there are too many people and it is too confusing to "make" people use a
consistent format by choice - they have to be forced to do so within the
report itself.
If the answer is "no" I'll continue using excel, but if it can be done,
could someone please point me in the right direction? I use word 97 (don't
ask) they use word 2000 (I think).
Thanks,
Fiona