Link Password Protected Worksheets to Master

P

PolQueen

I have 21 password protected Excel 2003 spreadsheets for employees in the
department to update their daily work. Each spreadsheet contains a 12 tabs
(one for each month. I need to create a master spreadsheet with links that
will update for the supervisor, which will have graphs and charts from the
linked data. I did January, and it took me two days, because I must type in
the password for each employee in each cell. How can I duplicate the Master
January tab for the other 11 months without typing the password in every
cell? HELP!!

I assume there must be a trick to go in and change the tab portion of the
formula, in this sample JAN' to FEB'.
='J:\Field Division Share Files\Commercial\Commercial Bi-Monthly Reports -
2008\[Bi-Monthly Report Alvarado.xls]JAN'!D6
 
R

Red

You can do a find / replace to find ]JAN and replace it with ]FEB. If the
February worksheet in the master file does not already have the links built
into it, then I would suggest doing a move / copy of the January file,
renaming it February (after you delete the original february worksheet since
you can't have two named the same thing) and then doing the find / replace.

Hope this makes sense.
 
P

PolQueen

Red:

Thanks for the reply. I already did that. Because I have passwords on all
21 of the workbooks, each cell asks for the password as I do the find and
replace. There are hundreds of cells, so this is too time consuming.

There must be some way around this.

Thanks!


Red said:
You can do a find / replace to find ]JAN and replace it with ]FEB. If the
February worksheet in the master file does not already have the links built
into it, then I would suggest doing a move / copy of the January file,
renaming it February (after you delete the original february worksheet since
you can't have two named the same thing) and then doing the find / replace.

Hope this makes sense.
--
Just a fellow Excel user here to help when I can.....


PolQueen said:
I have 21 password protected Excel 2003 spreadsheets for employees in the
department to update their daily work. Each spreadsheet contains a 12 tabs
(one for each month. I need to create a master spreadsheet with links that
will update for the supervisor, which will have graphs and charts from the
linked data. I did January, and it took me two days, because I must type in
the password for each employee in each cell. How can I duplicate the Master
January tab for the other 11 months without typing the password in every
cell? HELP!!

I assume there must be a trick to go in and change the tab portion of the
formula, in this sample JAN' to FEB'.
='J:\Field Division Share Files\Commercial\Commercial Bi-Monthly Reports -
2008\[Bi-Monthly Report Alvarado.xls]JAN'!D6
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top