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

Similar discussions

Messenger group link
aivaras1963 -
dwebb -

Hello. After upgraded messenger (app) group link dissapaers. How I can invite my friends to my messenger group now?

3 responses
WAN connection down
Gdubcwell75 -
ac3mark -

Hello,

One day, out of the blue, my router's WAN connection went down. I went through troubleshooting and turned it off and back on, yada yada yada. I followed the ethernet (or whatever its called) cable back the the phone jack on the wall where it plugs in and unplugged it. When I did that, I noticed a clear, sticky, almost booger like substance and I thought it might be some type of glue. However, this substance had found it's way into the connection and something told me that it doesnt belong there. Idk if something leaked through the wall or what it is but, I just would like to see if this has happened to anyone else. I've been with my internet provider for over a year an...

2 responses
Undo remove link
Sam -
Abhishek0025 -

Hello, Recently I accidentally removed my bio's link from my bf's account and now he can't mention me. How do I recover the link?

1 response
How to undo "remove link" in bio?
mary22 -
Gourav -

Hello,

I accidentally removed the link of my profile from my boyfriend's bio. Now, when he wants to mention me in his bio, the tag is not linked with my profile anymore. Is there any way to undo the function "remove link" ?

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

Hi, I am a regular user of Facebook and suddenly
my account was locked and I am trying to
confirm my identity to unlocked it but I can't find
any option to confirm my identity.
Kindly check my request and respond to my
concern as soon as possible.
Thank you.

1 response