|
|
#2
02-01-2016, 05:06 PM
|
||||
|
||||
This has nothing to do with the use of passwords, but with the fact that SUMIF references to external workbooks only work when those workbooks are open. You would get the same outcome without the passwords.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] 
|
| Tags |
| #value!, links, updates |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 combining spreadsheets
|
Jagerfred | Excel | 1 | 01-12-2016 12:42 PM |
|
Merging Two Spreadsheets
|
buechler66 | Excel Programming | 1 | 03-25-2015 11:57 AM |
|
Joining two (or more) spreadsheets without use of a 'ghost'
|
Richard121 | Excel | 2 | 02-16-2015 01:38 PM |
|
Can't open spreadsheets
|
kaygeea | Excel | 7 | 10-05-2011 08:00 AM |
|
Merging two spreadsheets
|
BrazzellMarketing | Excel | 5 | 04-26-2011 01:51 PM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode