Hi all
I have 12 collums with over 2000 rows containing a Sumproduct formula counting 3 Variable’s in each cell.
This is causing the Workbook to opperate very slowly
Please Login or Register to view this content.
Can i turn off the automatic Calculation on these Cells?
I have some other cells containing formula that i would like to keep running
Does anyone have any ideas on how this could be done?
Thanks
Maybe define named ranges instead of looking at the entire column:
June_B: =OFFSET(June!$B$1,0,0,COUNT(June!$B:$B))
Ben Van Johnson
Another suggestion would be to not use entire column ranges in teh SUMPRODUCT(), that will slow it down. Rather, restrict the ranges to just what you need
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thank you both for your suggestions
I have restricted the ranges in the sumproduct formula and this has solved the issue.
Happy to help and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks