Excel cell update slowly


H

Haritha Kolla

I have an excel sheet with 4 sheets;

first sheet using 250 columns and 300 rows; around 40 columns have simple
formula's, in which 20 columns have formula's refering to other sheet.

second sheet has 100 columns with 300 rows; 16 columns have vlookup formulas.

When user modifies the cell in first sheet, its taking longer time to update
the modified cell. On every cell change, we see the calculation running from
0 to 100%. The cell changes are updated slowly. The Calculation is set to
automatic. How should we fix this issue?
 
Ad

Advertisements

D

Don Guillett

If your vlookup formulas are using all rows, change to the only the area
reference.
=vlookup(a2,sheet2!a2:z100,12,0) instead of a:z
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top