Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Link Password Protected Workbooks
I have 21 password protected Excel 2003 workbooks for employees in the
Department to update their daily work. Each workbook contains 12 spreadsheets (one tab for each month). I created a master spreadsheet from the linked data in each employees workbook for the supervisor with summary data, graphs and charts. After I completed January, I tried copying the tab to update for February. When I do €śfind and replace€ť, I must type in each employees password for each cell as it replaces the month in the formula. How can I duplicate the Master (January) tab for the other 11 months without typing the password in every cell? A cell formula is: ='J:\Field Division Share Files\Commercial\Commercial Bi-Monthly Reports - 2008\[Bi-Monthly Report Alvarado.xls]JAN'!D6 I assume there must be a trick to go in and change the formula, in this sample JAN' to FEB'. There are thousands of cells, so it is too time consuming to type passwords in each cell. There must be some way around this. HELP!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Link Password Protected Workbooks
If you open those other 21 other workbooks (readonly so that others can still
use them), you won't see the prompt for the password. PolQueen wrote: I have 21 password protected Excel 2003 workbooks for employees in the Department to update their daily work. Each workbook contains 12 spreadsheets (one tab for each month). I created a master spreadsheet from the linked data in each employees workbook for the supervisor with summary data, graphs and charts. After I completed January, I tried copying the tab to update for February. When I do €śfind and replace€ť, I must type in each employees password for each cell as it replaces the month in the formula. How can I duplicate the Master (January) tab for the other 11 months without typing the password in every cell? A cell formula is: ='J:\Field Division Share Files\Commercial\Commercial Bi-Monthly Reports - 2008\[Bi-Monthly Report Alvarado.xls]JAN'!D6 I assume there must be a trick to go in and change the formula, in this sample JAN' to FEB'. There are thousands of cells, so it is too time consuming to type passwords in each cell. There must be some way around this. HELP!! -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Link Password Protected Workbooks
That worked! You have just saved me a ton of time.
THANK YOU! "Dave Peterson" wrote: If you open those other 21 other workbooks (readonly so that others can still use them), you won't see the prompt for the password. PolQueen wrote: I have 21 password protected Excel 2003 workbooks for employees in the Department to update their daily work. Each workbook contains 12 spreadsheets (one tab for each month). I created a master spreadsheet from the linked data in each employee€„˘s workbook for the supervisor with summary data, graphs and charts. After I completed January, I tried copying the tab to update for February. When I do €œfind and replace€, I must type in each employee€„˘s password for each cell as it replaces the month in the formula. How can I duplicate the Master (January) tab for the other 11 months without typing the password in every cell? A cell formula is: ='J:\Field Division Share Files\Commercial\Commercial Bi-Monthly Reports - 2008\[Bi-Monthly Report Alvarado.xls]JAN'!D6 I assume there must be a trick to go in and change the formula, in this sample JAN' to FEB'. There are thousands of cells, so it is too time consuming to type passwords in each cell. There must be some way around this. HELP!! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Link to a password protected file | Excel Discussion (Misc queries) | |||
Excel Macro to open password protected workbooks? | Excel Discussion (Misc queries) | |||
Links to password protected workbooks | Excel Discussion (Misc queries) | |||
Password protected workbooks | Excel Discussion (Misc queries) | |||
Link to password protected workbook | Excel Discussion (Misc queries) |