Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Link Password Protected Worksheets to Master
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Link Password Protected Worksheets to Master
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" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Link Password Protected Worksheets to Master
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" wrote: 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" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Link to a password protected file | Excel Discussion (Misc queries) | |||
Link Worksheets Into Master | Excel Discussion (Misc queries) | |||
How do I link password protected files to a master spreadsheet? | Excel Worksheet Functions | |||
Multiple workbook user's with Master workbook - all password protected | Excel Discussion (Misc queries) | |||
Link to password protected workbook | Excel Discussion (Misc queries) |