Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup function 2003
Hi Guys,
My first post on the forums. I work for a small insurance company in the UK using MS excel for stochastic modelling. My company has been office 2000(!) for a ages, and have finally taken the 'plunge' and upgraded... to office 2003. So far so good - I like it :). Sadly, since the upgrade, most of our models run significantly slower, as in they take twice/three times as long to run. We are wondering if this could be something to do with the implemenation of the vlookup function. The increased slowness seems to be proportional to the number of vlookups we have in the model - this is speculative, but there does look to be a pattern. Does anyone know if the implemenation has changed Excel 2000 - 2003, or if this could be a reason? Are there any other suggestions or has anyone come across this before? Parts of the models would be hard (read very hard) to implement without the vlookup'ing up - but it would be nice to know so we can avoid where possible if this is the case. Thanks, Simon |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup function 2003
Hi Simon,
I am not sure what level of lookup is used in your models however these checks might help. 1. Set the calculation mode to manual from Tools--Options--Calcution 2. See if you have installed addins such as Analysis ToolPak, Solver Add-in. You can check this from Tools--Addins. If not installed, please ask your IT to install it for you, usually done from the MS Office (Excel) Set up program. 3. If your models are using any other addins programmed in Excel 2000, which are not installed currently. 4. Check for any broken links or broken server/network addresses. Hope this helps!! -- Pranav Vaidya VBA Developer PN, MH-India If you think my answer is useful, please rate this post as an ANSWER!! "Simon" wrote: Hi Guys, My first post on the forums. I work for a small insurance company in the UK using MS excel for stochastic modelling. My company has been office 2000(!) for a ages, and have finally taken the 'plunge' and upgraded... to office 2003. So far so good - I like it :). Sadly, since the upgrade, most of our models run significantly slower, as in they take twice/three times as long to run. We are wondering if this could be something to do with the implemenation of the vlookup function. The increased slowness seems to be proportional to the number of vlookups we have in the model - this is speculative, but there does look to be a pattern. Does anyone know if the implemenation has changed Excel 2000 - 2003, or if this could be a reason? Are there any other suggestions or has anyone come across this before? Parts of the models would be hard (read very hard) to implement without the vlookup'ing up - but it would be nice to know so we can avoid where possible if this is the case. Thanks, Simon |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup function 2003
Why would solver has anything to do with a workbook being slower when used
in 2003? -- Regards, Peo Sjoblom "Pranav Vaidya" wrote in message ... Hi Simon, I am not sure what level of lookup is used in your models however these checks might help. 1. Set the calculation mode to manual from Tools--Options--Calcution 2. See if you have installed addins such as Analysis ToolPak, Solver Add-in. You can check this from Tools--Addins. If not installed, please ask your IT to install it for you, usually done from the MS Office (Excel) Set up program. 3. If your models are using any other addins programmed in Excel 2000, which are not installed currently. 4. Check for any broken links or broken server/network addresses. Hope this helps!! -- Pranav Vaidya VBA Developer PN, MH-India If you think my answer is useful, please rate this post as an ANSWER!! "Simon" wrote: Hi Guys, My first post on the forums. I work for a small insurance company in the UK using MS excel for stochastic modelling. My company has been office 2000(!) for a ages, and have finally taken the 'plunge' and upgraded... to office 2003. So far so good - I like it :). Sadly, since the upgrade, most of our models run significantly slower, as in they take twice/three times as long to run. We are wondering if this could be something to do with the implemenation of the vlookup function. The increased slowness seems to be proportional to the number of vlookups we have in the model - this is speculative, but there does look to be a pattern. Does anyone know if the implemenation has changed Excel 2000 - 2003, or if this could be a reason? Are there any other suggestions or has anyone come across this before? Parts of the models would be hard (read very hard) to implement without the vlookup'ing up - but it would be nice to know so we can avoid where possible if this is the case. Thanks, Simon |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup function 2003
I'm not aware of any performance degradation of VLOOKUPs between 2000 and 2003.
For tons of information about Excel performance, with special chapter for VLOOKUP, visit Charles Williams' site: www.decisionmodels.com -- Kind regards, Niek Otten Microsoft MVP - Excel "Simon" wrote in message ... | Hi Guys, | | My first post on the forums. I work for a small insurance company in the UK | using MS excel for stochastic modelling. My company has been office 2000(!) | for a ages, and have finally taken the 'plunge' and upgraded... to office | 2003. So far so good - I like it :). | | Sadly, since the upgrade, most of our models run significantly slower, as in | they take twice/three times as long to run. We are wondering if this could be | something to do with the implemenation of the vlookup function. The increased | slowness seems to be proportional to the number of vlookups we have in the | model - this is speculative, but there does look to be a pattern. | | Does anyone know if the implemenation has changed Excel 2000 - 2003, or if | this could be a reason? Are there any other suggestions or has anyone come | across this before? Parts of the models would be hard (read very hard) to | implement without the vlookup'ing up - but it would be nice to know so we can | avoid where possible if this is the case. | | Thanks, | Simon |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Help with VLookup in Excel 2003 please | Excel Worksheet Functions | |||
HOW DO I NEST THE VLOOKUP FUNCTION WITH THE LEFT FUNCTION | Excel Worksheet Functions | |||
how do I write a vlookup function within an iserror function so t. | Excel Worksheet Functions | |||
I want to use Vlookup function and AND function in a single formu. | Excel Worksheet Functions |