#NA in 2, all others OK
 

In XL2K I have a range of cells linked to a password protected workbook
I did it using Paste Special Paste Link with both files open
I close and save both files
I open the file with the links
I'm prompted for the password for the password protected book
TWO of the cells display #NA and it's the same two every time
If I actually open the password protected file, all is well

What would explain the fact that all other links update properly without
opening the protected book except these two?

--
David

Why not post the actual links that you're using?

Might these links be formulas linked to data in the other WB?
Some functions *don't* work with closed WBs.
Add to that, some volatile functions will calculate all the time, not even
giving you a chance to retain the old values from when the WB was last
opened.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"David" wrote in message
...
In XL2K I have a range of cells linked to a password protected workbook
I did it using Paste Special Paste Link with both files open
I close and save both files
I open the file with the links
I'm prompted for the password for the password protected book
TWO of the cells display #NA and it's the same two every time
If I actually open the password protected file, all is well

What would explain the fact that all other links update properly without
opening the protected book except these two?

--
David

Ragdyer wrote

Why not post the actual links that you're using?

Might these links be formulas linked to data in the other WB?
Some functions *don't* work with closed WBs.
Add to that, some volatile functions will calculate all the time, not
even giving you a chance to retain the old values from when the WB was
last opened.
--
Regards,

RD

Links are straightforward and refer to cells containing only text:

='C:\Data\EXCEL\[ETHRA RIDE LIST.XLS]List'!A17
='C:\Data\EXCEL\[ETHRA RIDE LIST.XLS]List'!A18
='C:\Data\EXCEL\[ETHRA RIDE LIST.XLS]List'!A19
='C:\Data\EXCEL\[ETHRA RIDE LIST.XLS]List'!A20
='C:\Data\EXCEL\[ETHRA RIDE LIST.XLS]List'!A21
='C:\Data\EXCEL\[ETHRA RIDE LIST.XLS]List'!A22 <-- #NA
='C:\Data\EXCEL\[ETHRA RIDE LIST.XLS]List'!A23
='C:\Data\EXCEL\[ETHRA RIDE LIST.XLS]List'!A24
='C:\Data\EXCEL\[ETHRA RIDE LIST.XLS]List'!A25
='C:\Data\EXCEL\[ETHRA RIDE LIST.XLS]List'!A26
='C:\Data\EXCEL\[ETHRA RIDE LIST.XLS]List'!A27
='C:\Data\EXCEL\[ETHRA RIDE LIST.XLS]List'!A28
='C:\Data\EXCEL\[ETHRA RIDE LIST.XLS]List'!A29
='C:\Data\EXCEL\[ETHRA RIDE LIST.XLS]List'!A30
='C:\Data\EXCEL\[ETHRA RIDE LIST.XLS]List'!A31
='C:\Data\EXCEL\[ETHRA RIDE LIST.XLS]List'!A32 <-- #NA
='C:\Data\EXCEL\[ETHRA RIDE LIST.XLS]List'!A33
='C:\Data\EXCEL\[ETHRA RIDE LIST.XLS]List'!A34
='C:\Data\EXCEL\[ETHRA RIDE LIST.XLS]List'!A35
='C:\Data\EXCEL\[ETHRA RIDE LIST.XLS]List'!A36
='C:\Data\EXCEL\[ETHRA RIDE LIST.XLS]List'!A37
='C:\Data\EXCEL\[ETHRA RIDE LIST.XLS]List'!A38
='C:\Data\EXCEL\[ETHRA RIDE LIST.XLS]List'!A39
='C:\Data\EXCEL\[ETHRA RIDE LIST.XLS]List'!A40

Observations:
All except those indicated return proper results
If I remove password from ETHRA RIDE LIST, all is OK
If I reapply password, same two return #NA

News Flash!!
Tried an experiment
Opened ETHRA RIDE LIST
Put a 'Z' in front of the 2 troublesome names
Sorted the table, which properly moved them to end
Saved and closed
Opened book with links, no #NA's, changed names were at end of list
Reopened ETHRA RIDE LIST, took Z's out, resorted, saved, closed
Reopened book with links, no #NA's, all names in sorted order

Very puzzled, but happy now

--
David