LinkBack URL
About LinkBacks
Does anybody have any idea, why does the Sumproduct formula not update when source wbook is closed. These files even in trusted locations.
Cheers!
SUMPRODUCT returns #REF! unless source workbook is open
Does anybody have any idea, why does the Sumproduct formula not update when source wbook is closed. These files even in trusted locations.
Cheers!
Wow!!!! What a lot of detail!!!
What formula are you using?
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
If you have an INDIRECT in the formula: it won't work on closed sheets. If you're using structured table references in the formula, they won't work either...
Thank you,
I have figured it out, I was using table references in my formula that's why it doesn't calculate when it was close. However I prefer not to calculate automatically, because when I use entire column in formula, both my workbooks slows down.
New question is there anyway to prevent slow downs with automatic calculation is turned on?
cangokturk
Can you select a range, rather than the whole column, but use a range that's "reasonably" future proof? Do you really need to include 1,000,000 rows - which is what you're using with whole column refs.??
Don't use entire columns as references with the SUMPRODUCT function.Originally Posted by cangokturk
Use smaller specific ranges:
NO: A:A
YES: A2:A1000
If you don't know how much data there might be then just use a range size that you know you won't exceed.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Thank you Glenn for the explanation. Your staement was very intelligible.
You're welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks