software

I have a lot of vlookups and I have tried everything. The data is one the
same workbook, the data is copy past value so that it isn't tying to
anything. I don't have any links on this sheet, but sometime it takes 20-40
minutes to calculate. It doesn't tie up the machine, but it shouldn't take
that long

Please post your formulas. Is the data sorted? What values are you looking
for? How big are the ranges?

For good advice on performance (especially for lookups), visit

www.decisionmodels.com--
Kind regards,

Niek Otten

quot;Emomquot; gt; wrote in message
...
gt;I have a lot of vlookups and I have tried everything. The data is one the
gt; same workbook, the data is copy past value so that it isn't tying to
gt; anything. I don't have any links on this sheet, but sometime it takes
gt; 20-40
gt; minutes to calculate. It doesn't tie up the machine, but it shouldn't
gt; take
gt; that long
There are 35 sheets of 100 columns and 120 rows of vlookups. I have 512 MB
of ram so there should be no problem with memory

quot;Kevin Mquot; wrote:

gt; Emom, how many VLOOKUPs are we talking here? What kind of hardware?
gt;
gt; quot;Emomquot; wrote:
gt;
gt; gt; I have a lot of vlookups and I have tried everything. The data is one the
gt; gt; same workbook, the data is copy past value so that it isn't tying to
gt; gt; anything. I don't have any links on this sheet, but sometime it takes 20-40
gt; gt; minutes to calculate. It doesn't tie up the machine, but it shouldn't take
gt; gt; that long

That's 420,000 VLOOKUPs?! I think some examples of these would be pertinent
to help you find another solution instead of the VLOOKUP's.

Kevin M

quot;Emomquot; wrote:

gt; There are 35 sheets of approximately 100 columns and 120 rows of vlookups.
gt;
gt; quot;Niek Ottenquot; wrote:
gt;
gt; gt; Please post your formulas. Is the data sorted? What values are you looking
gt; gt; for? How big are the ranges?
gt; gt;
gt; gt; For good advice on performance (especially for lookups), visit
gt; gt;
gt; gt; www.decisionmodels.com
gt; gt;
gt; gt;
gt; gt; --
gt; gt; Kind regards,
gt; gt;
gt; gt; Niek Otten
gt; gt;
gt; gt; quot;Emomquot; gt; wrote in message
gt; gt; ...
gt; gt; gt;I have a lot of vlookups and I have tried everything. The data is one the
gt; gt; gt; same workbook, the data is copy past value so that it isn't tying to
gt; gt; gt; anything. I don't have any links on this sheet, but sometime it takes
gt; gt; gt; 20-40
gt; gt; gt; minutes to calculate. It doesn't tie up the machine, but it shouldn't
gt; gt; gt; take
gt; gt; gt; that long
gt; gt;
gt; gt;
gt; gt;

When you quot;Pase Special-gt;Valuesquot;, even though the information you are pasting
isn't calculating, Excel re-calculates everything in the spreadsheet (if you
have automatic calculation turned on). Try turning automatic calculation
off: Tools-gt;Options-gt;'Calculation' tab-gt;check 'Manual'--
Regards,
Davequot;Emomquot; wrote:

gt; I have a lot of vlookups and I have tried everything. The data is one the
gt; same workbook, the data is copy past value so that it isn't tying to
gt; anything. I don't have any links on this sheet, but sometime it takes 20-40
gt; minutes to calculate. It doesn't tie up the machine, but it shouldn't take
gt; that long

There are 35 sheets of approximately 100 columns and 120 rows of vlookups.

quot;Niek Ottenquot; wrote:

gt; Please post your formulas. Is the data sorted? What values are you looking
gt; for? How big are the ranges?
gt;
gt; For good advice on performance (especially for lookups), visit
gt;
gt; www.decisionmodels.com
gt;
gt;
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt; quot;Emomquot; gt; wrote in message
gt; ...
gt; gt;I have a lot of vlookups and I have tried everything. The data is one the
gt; gt; same workbook, the data is copy past value so that it isn't tying to
gt; gt; anything. I don't have any links on this sheet, but sometime it takes
gt; gt; 20-40
gt; gt; minutes to calculate. It doesn't tie up the machine, but it shouldn't
gt; gt; take
gt; gt; that long
gt;
gt;
gt;

Dave, that will solve the problem but not the cause. As soon as he does
calculate it'll take twenty minutes again. There has to be more to this
problem... If he's got say, 10,000 VLOOKUPs it's a cause for concern.

Kevin M

quot;David Billigmeierquot; wrote:

gt; When you quot;Pase Special-gt;Valuesquot;, even though the information you are pasting
gt; isn't calculating, Excel re-calculates everything in the spreadsheet (if you
gt; have automatic calculation turned on). Try turning automatic calculation
gt; off: Tools-gt;Options-gt;'Calculation' tab-gt;check 'Manual'
gt;
gt;
gt; --
gt; Regards,
gt; Dave
gt;
gt;
gt; quot;Emomquot; wrote:
gt;
gt; gt; I have a lot of vlookups and I have tried everything. The data is one the
gt; gt; same workbook, the data is copy past value so that it isn't tying to
gt; gt; anything. I don't have any links on this sheet, but sometime it takes 20-40
gt; gt; minutes to calculate. It doesn't tie up the machine, but it shouldn't take
gt; gt; that long

Emom, how many VLOOKUPs are we talking here? What kind of hardware?

quot;Emomquot; wrote:

gt; I have a lot of vlookups and I have tried everything. The data is one the
gt; same workbook, the data is copy past value so that it isn't tying to
gt; anything. I don't have any links on this sheet, but sometime it takes 20-40
gt; minutes to calculate. It doesn't tie up the machine, but it shouldn't take
gt; that long

EMOM,

WHY NOT JUST ANSWER THE QUESTIONS OF THOSE WHO TRY TO HELP YOU?

quot;Please post your formulas. Is the data sorted? What values are you looking
for? How big are the ranges?quot;

--
Kind regards,

Niek Otten

quot;Emomquot; gt; wrote in message
...
gt; There are 35 sheets of 100 columns and 120 rows of vlookups. I have 512
gt; MB
gt; of ram so there should be no problem with memory
gt;
gt; quot;Kevin Mquot; wrote:
gt;
gt;gt; Emom, how many VLOOKUPs are we talking here? What kind of hardware?
gt;gt;
gt;gt; quot;Emomquot; wrote:
gt;gt;
gt;gt; gt; I have a lot of vlookups and I have tried everything. The data is one
gt;gt; gt; the
gt;gt; gt; same workbook, the data is copy past value so that it isn't tying to
gt;gt; gt; anything. I don't have any links on this sheet, but sometime it takes
gt;gt; gt; 20-40
gt;gt; gt; minutes to calculate. It doesn't tie up the machine, but it shouldn't
gt;gt; gt; take
gt;gt; gt; that long