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

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

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,113,795
Messages
5,544,332
Members
410,603
Latest member
rseckler
Top