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?