Hi
Every user uses only it's own sheet, and you yourself have some general
sheet, which supports users with some general data and maybe get's some
generalised data from them? When yes, then you'll have a lot less of
trouble, when you create a separate workbook for every user. Advantages for
such design:
1. Every user's workbook can be protected with password for opening. Excel's
protection isn't anything great, but it protects at least from accidental
harm.
2. All users can work independently from others - no messages about workbook
been opened as read-only anymore.
3. Whenever a workbook will be damaged, only data from this user are lost/do
need restoring.
You can attach data from summary/general workbook to user's workbooks and
vice versa using links. Mostly you can embedd links directly into formulas,
without bothering the source workbook being closed or opened. But there are
some functions, which are working with links to opened workbooks only. When
this is the case, then you have to mirror the source data into target
workbook, and use mirrored data as source in your formulas.
NB! By such design you have to determine strictly, where are linked data
entered/edited, and where are they viewed. And it's best you protect all
formulas with links from accidental changes (sheet protection).
I myself used such design for registering working time and absences in
factory departments (~25 of them), and gathering summary about it for
factory.
To give more detailed advice, I have to know at least a bit what do you want
to do, and about data you need to share. I hope you got at least some ideas.
--
(When sending e-mail, use address (e-mail address removed))
Arvi Laanemets
Judy said:
Hi,
I have a workbook which contains about 13 sheets and which is shared by other users. I need to know...
1. I want to be able to link data from the main sheet to the particular
user's sheet, so that when i enter data in the main sheet, that data should
be re-produced in that user's sheet.
2. How do I hide all other sheets and ensure that only user "X" can
read-only his sheet? Other sheets should not be visible.
