What do you mean by "breaking the password"???




"Raj" wrote in message
...
Hi Stephan

How about breaking the password for all the 30 files??? Let me know if you
are interested and mail me personally.

Bye and Take Care!!

"Stephen Larivee" wrote:

Thank you. I will have to rethink this.

Thanks again.



"Dave Peterson" wrote in message
...
I think you're asking the impossible if you just work with passwords.

You could save the workbooks with the
file|saveas|tools|general options|"password to modify" set

You won't be prompted for a password for your links. But anyone could
open that
workbook and see all the data (in readonly mode, though).

In fact, if you could see the links you wanted (without a password),
then
anyone
could build their own link and point at any/all cells and see
everything.

One option would be to have a workbook that knows all the filenames and
passwords and opens each and copies the relevant information from each
and
creates a new workbook (without the links--just the values) that any
one
could
access.

I think if I were doing this, I wouldn't take a chance that someone
could
break
into my workbook and see all the filenames/passwords.

I think I'd run that on demand (whenever I had to).

===
Another option. You update that summary workbook. Open all the files,
have the
links update, and save it with the current values.

Tell the other users that they should not update links when they open
that
summary workbook.

But you'd want to open the 30 workbooks before you open the summary
workbook
(with links). Then you could avoid all the prompts.

saved from a previous post:

Maybe you could create a macro that would open all those workbooks
first.

Your macro would supply both the workbook's name and password.

Then after all these workbooks are open, you could open the file that
contains
the links.

Kind of like:

option explict
sub auto_open()
dim wkbk1 as workbook
dim wkbk2 as workbook
dim wkbk3 as workbook

set wkbk1 = workbooks.open(filename:="c:\a.xls",password:="one ")
set wkbk2 = workbooks.open(filename:="c:\b.xls",password:="two ")
set wkbk3 = workbooks.open(filename:="c:\c.xls",password:="thr ee")

'wkbk3 is the real one!

wkbk1.close savechanges:=false
wkbk2.close savechanges:=false
'thisworkbook.close savechanges:=false
end sub

(I'd create a 4th workbook that opens the files in order and just
closes
the
first 2 and then itself.)



Stephen Larivee wrote:

I am trying to help a friend with an Excel project. She is a teacher.
We
are using Excel 2002.

She would like to have 30 files for 30 people on a network drive
everyone
can access Each of the 30 files would be password protected. (Save
As,
Tools, General Options). Each person could access her own file but no
one
else's.

She would like me to create a Grand Total sheet that would take data
from
each of the 30 files and link the data to show the overall totals.
Everyone
could see the totals, but they could not see the individual scores
each
teacher had.

I can do all of the above. The problem is that when you open the
Grand
Total file which is not password protected, you are told that the
links
must
be updated. If you click to update, you are then prompted for all the
passwords. This is too much work for each person to do, plus it gives
them
passwords to get into the 30 files so there goes your security.

I guess I am asking two contradictory things from Excel. First, I am
saying
I want to password protect some data in the 30 files. But then I want
Excel
to make the data available in the Grand Total sheet for anyone to see.

Does anyone have any suggestions on how I could set up Excel to
achieve
my
goals? Or am I asking the impossible?

TIA

--

Dave Peterson