| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protecting data
I have this Excel problem, I thought I'd check to see if anyone have any
ideas hopefully without using VBA. I have a spreadsheet that will live on the network displaying student data, course number, number of students in the class, language, level etc. This spreadsheet is linked to another workbook also on the network that has the source data. This includes the raw data from our database plus formulas etc that summarises the data for it to feed into the main spreadsheet. Trying to protect the main sheet, make it read only etc does not work as one can still reach the source via the links option. Protecting the source data with a password means that the links would not be updated. Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| password protecting a column for data entry in a sheet, how? | Excel Worksheet Functions | |||
| Protecting cells but maintaing data groups | Excel Discussion (Misc queries) | |||
| Protecting formulae while still using expand and minimise data gro | Excel Discussion (Misc queries) | |||
| Protecting excel sheet for data input | Excel Discussion (Misc queries) | |||
| Protecting Validated cells from pasting over data | Excel Discussion (Misc queries) | |||
Threaded Mode
