very thanks to excelforum.com, i learnt many functions from ths site. And others directly made formula in my official excel. Now problem is my excel slow. Recently i created many lookup functions, after that my excel speed down. Anyway to possible speed? I dont want remove formula. All formula reduce my work. So only
Try to reduce the range of your vlookups, instead of using entire rows or columns, only use the minimum range needed
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
Replacing VLOOKUP's with INDEX/MATCH combinations should also help
Maybe you can set the calculation to manual.
This stops Excel from doing calculations every time change a cell. Press F9 when need it.
Hope this help
-If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".
-Always upload a workbook before start your question
To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
+++ If my answer(s) helped you, please add me reputation by click on * +++
i will try above what all you said. thank....................
Lots of info here:
http://msdn.microsoft.com/en-us/library/aa730921.aspx
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks