hello
i am working with relatively large excel files about 25 mb each.
i am using formulas of sumifs, sumif, if combined for over 1600 row in one sheet and over 10000 row in another sheet in the same workbook.
in other sheets i have index+match formula combined, and a sumif based on dragbox in other.
the file is taking time during calc. even when changing 1 value only.
any solution for the file itself?
or in the laptop i am working with? any advise ?
Turn OFF automatic calculation, then go to VBA editor and create small macro as below:
then You can select range and run calculation only for selected cells (ex. assign keywords for it).
Please Login or Register to view this content.
Happy with my answer * Add Reputation.
If You are happy with solution, please use Thread tools and mark thread as SOLVED.
Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)
Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?
To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
(note: this change is not optionalNo Help to be offered until this moderation request has been fulfilled)
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks