I have a curious issue. A coworker sent me two spreadsheets, which are
linked up that totals up values for each individual county. The counties
fill out their own spreadsheets and e-mail them in for this coworker to
update her master spreadheet. For whatever reason, one of the counties is
bringing back incorrect data. When I view the reference here is what I see:
=('C:\Users\nmara1\Desktop\[Mohave July.xls]Intensive Page 3'!$F$12)
What is strange about his, is that on the Mohave July.xls spreadsheet there
is no Intensive Page 3 tab. Shouldn't that return a #REF error message? It
actually returns a value, but I am not sure from where. Is there a way for
that tab to be hidden, and if so how would i unhide to see?

Sedondly, how does one go about updating a source document for all 15 tabs
in a quick fashion? I tried using dataconnectionrefresh all and I also
tried dataedit links .. but nothing seemed to happen.

I might be missing something simple here...

Any assistance would be appreciated.