Previous Topic Next Topic

Link between Workbooks

Closed
drewd4 Posts 1 Registration date Tuesday September 3, 2013 Status Member Last seen September 3, 2013 - Sep 3, 2013 at 10:32 AM
Sixthsense Posts 1 Registration date Saturday September 7, 2013 Status Member Last seen September 7, 2013 - Sep 7, 2013 at 08:32 AM
New to the forum, hope someone can help! Let me know if I need to clarify my question and thanks in advance.

When using formulas to link one workbook to another, is it possible to embed the information from the original workbook so that the correct sum appears in the newly created workbook without the original workbook being open?

Currently, the cells with linked data show the message #VALUE until the original workbook is al open.

Thanks!
Related:

1 response

Answer 1 / 1
Sixthsense Posts 1 Registration date Saturday September 7, 2013 Status Member Last seen September 7, 2013
Sep 7, 2013 at 08:32 AM
Not sure what function you are using to calculate the sum...

Sum and Sumproduct will work on closed workbooks

But Sumif(s) or Countif(s) and Indirect won't work with closed workbooks


---
Sixthsense
0

Similar discussions

Messenger group link
aivaras1963 -
dwebb -

3 responses
Can't join WhatsApp group chat
Matt92 -
vocalkeny -

25 responses
Please give me link to unlock my Facebook account
Andeccuasay -
HelpiOS -

1 response
Cannot Open 192.168.1.1 with TP-link
Gsimar -
kureka -

9 responses
How to undo "remove link" in bio?
mary22 -
Gourav -

13 responses