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

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

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,701
Messages
5,573,704
Members
412,548
Latest member
wallisonlac
Top