#NA in 2, all others OK

  • Thread starter Thread starter David
  • Start date Start date
D

David

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?
 
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.
 
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.
Click to expand...

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Protection 2
Excel Opening Problems ? And, Other Equiv Spreadsheets ? 1
Linking to Password Protect Workbooks 23
Password Protecting a workbook 2
protection 2
Not your usual password question! 6
Opening a password-protected spreadsheet from a website link 1
Hyperlinks in cells in a protected worksheet not working 5

Back
Top