| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
worksheet protecting interefering with file links
Hi!
I have two separate excel files that are linked, and when i do not have any password protection on the worksheets, i can save modified versions of one of the files and use the "Edit" "Links" option to change the source file. However, when i password protect the worksheets, i can no longer do this. Is there a way around this so that i can have a protected worksheet with some locked cells, but still be able to update file links? -- thanks!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
worksheet protecting interefering with file links
If anyone has advice regarding this question i would very much
appreciate some sinsight as well. Thank you! coriolis wrote: Hi! I have two separate excel files that are linked, and when i do not have any password protection on the worksheets, i can save modified versions of one of the files and use the "Edit" "Links" option to change the source file. However, when i password protect the worksheets, i can no longer do this. Is there a way around this so that i can have a protected worksheet with some locked cells, but still be able to update file links? -- thanks!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Saving to a worksheet in another file...? | Excel Discussion (Misc queries) | |||
| Weird File Open/Save As Behavior | Excel Discussion (Misc queries) | |||
| Data from Excel 2000 Worksheet with external links is not displayed when opened in Excel 2003 | Links and Linking in Excel | |||
| Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
| Some formulas need file refresh in same worksheet | Excel Worksheet Functions | |||
Hybrid Mode
