I am having a problem linking cels from one spreadsheet file to another.
When I the link I get an error message "#Ref!. However, in another part of
the spreadsheet the same method produces the expected results. Further,
confusing me is when I paste the reference to the second shee, I get the
expected results. This leads me to believe that there is some attribute on
the sheet in question, but I have not been able to decipher it.
Any help will be appreciated especially since I'm on a short deadline.
Thank you
Charles F. Haas
Treasurer
South Indian River Water Control District