Updating Excelsheet with conected VLOOKUP sheets time consuming

[tmarko]

I have a workbook with several sheets. Some sheets connects via VLOOKU
to an updatable sheet with raw data. When I try to update data (impor
from database) to the raw data sheet. It takes forever and I think thi
is casued by the "linked" VLOOKUPs to from the other sheets to thi
rawdata sheet, beacuse when I have tried to update the rawdata shee
without "connected" VLOOKUP sheets it does not take forever.

Is it possibel to solve this?

I have tryed

Application.ScreenUpdating = False

without success, maybe because the VLOOKUPs are in the othersheets no
in the rawsheets that is beeing updated, just a guess

 

[jeff]

Hi,

I believe that if you turn off automatic calculation
until after your import, you'll be faster.

jeff

 

[tmarko]

Thanks works fine!

Use these

Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
Application.CalculateBeforeSave = True

then after uppdating

Application.Calculate
Application.Interactive = True
Application.DisplayAlerts = True
Application.ScreenUpdating = Tru