Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using ISTEXT across separate Spreadsheets
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 ------------------------------------------------------------------------ Adrena1in's Profile: http://www.excelforum.com/member.php...o&userid=35929 View this thread: http://www.excelforum.com/showthread...hreadid=557224 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using ISTEXT across separate Spreadsheets
Adrena1in Wrote: The spreadsheets being queried are protected, (protected worksheet and workbook), but other cells in these spreadsheets CAN be queried using the ISTEXT function.Forgot to mention, if I do unprotect the referenced spreadsheet, the ISTEXT function does then become able to query the specific cells. But I don't think protection is the problem, because other cells in the referenced spreadsheet can be accessed even when the spreadsheet remains protected. (Shrug) -- Adrena1in ------------------------------------------------------------------------ Adrena1in's Profile: http://www.excelforum.com/member.php...o&userid=35929 View this thread: http://www.excelforum.com/showthread...hreadid=557224 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I merge data from separate spreadsheets | Excel Discussion (Misc queries) | |||
More problems linking spreadsheets | Excel Discussion (Misc queries) | |||
updating separate spreadsheets | Excel Worksheet Functions | |||
how do i combine two separate spreadsheets? | Excel Discussion (Misc queries) | |||
Separate Spreadsheets | Excel Worksheet Functions |