Using ISTEXT across separate Spreadsheets

[Adrena1in]

Hi there,

I've got a customer with a single spreadsheet, which uses the ISTEXT
function to query lots of other spreadsheets. This appears to be
failing, and I can't figure out why.

The spreadsheets being queried are protected, (protected worksheet and
workbook), but other cells in these spreadsheets CAN be queried using
the ISTEXT function...it's just some specific cells which can't be
queried. The failing cells don't appear to be different to any of the
other ones.

The failing ISTEXT function produces a "#N/A" error, but the help isn't
helpful at all.

Has anyone seen this before, and knows what the problem might be
please?

Thanks,
Tim.

 

[Adrena1in]

The spreadsheets being queried are protected, (protected worksheet an
workbook), but other cells in these spreadsheets CAN be queried usin
the ISTEXT function.Forgot to mention, if I do unprotect the referenced spreadsheet, th

ISTEXT function does then become able to query the specific cells. Bu
I don't think protection is the problem, because other cells in th
referenced spreadsheet can be accessed even when the spreadshee
remains protected.

(Shrug