Using ISTEXT across separate Spreadsheets

  • Thread starter Thread starter Adrena1in
  • Start date Start date
A

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 said:
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
Click to expand...
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
 
Back
Top