 |
|
| Browse | Ask | Answer | Search | Join/Login |
|
|
||||
|
Linking to Workbook in Excel Using COUNTIF
I'm linking one workbook to another using a COUNTIF function. For some reason its only successful when the source book is open. The destination book links and updates. But when I close the source book and update, I get a #VALUE error. When I use a SUM function it is successful and updates the destination workbook regardless if the source book is open. Are there certain function that foreign linking can work with? Or is my StartUp folder missing something?
Thanks! |
||||
Check out some similar questions!
Hi, I have many worksheets within the same file, what I really want is to have either a (link / go to option) from sheet1 to other sheets without using hyperlink because I want to send to others. Example: if I click on Apple from Sheet 1, I will go to Sheet2 Sheet1 Sheet2 ...
Hello::confused: How do I link cells in worksheet to cells in another worksheet within the same book? When editing data in a worksheet, I would like for it to automatically update the summary page. Thanks PCan
I'd like to link from a cell in one worksheet to a LINE in another. If that doesn't make sense, I've got a member list of people with address, phone, etc. For folk that have not renewed this year, I want to have a separate worksheet that documents my contact efforts... so to link from the...
My friend asked me the code used to link a banner pic inserted in his email to his website. He wishes to put the animated banner in his emails and have the recipient be able to click the banner and be directed to his website. The first question is how to insert the banner picture into his...
View more questions Search
| Question Tools | Search this Question |
Add your answer here.
|
