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?

Perhaps you can create a PDF file from your source data, so users
can't amend it. Or, pehaps a macro in your source file is run
periodically to create the summary file as a stand-alone file which
doesn't need to be linked directly to the main file.

Hope this helps.

Pete

On Aug 13, 9:17*am, nc wrote:
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?