stop calculation of formulas

ehsas69

Board Regular
Joined
Jan 10, 2004
Messages
221
I have a excel sheet which has a set of formula.the problem I am facing is that when I import the database in the excel sheet field the excel sheet start calculation which slow the process.Is there any way to put a formula of macro in the file to stop calculation at time of importing the database and calculation start after the database been imported.

Thanks
 

Some videos you may like

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
Can you not simply switch calculation to Manual? Tools>Options>Calculation tab and check the Manual Calculation checkbox. You'll have to hit F9 or Shift+F9 to get the workbook/worksheet to recalc the formulas following importation.

Richard
 

Watch MrExcel Video

Forum statistics

Threads
1,118,656
Messages
5,573,423
Members
412,529
Latest member
cTatch
Top