Home |
Search |
Today's Posts |
#1
|
|||
|
|||
#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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|