I've noticed that in some excel files the hyperlink function is active, but
in other files it is not active. I haven't been able to figure out why some
files work and some don't. Is there some sort of worksheet protection
feature that allows some editing but does not allow hyperlinks?

Thanks