Formulas - Please urgent

Hello,

We are developing a Toolbar in Excel using VB, XML and VBA and populating data from our server to client remote machine.

Example:

Objective is to populate data in Sheet1 (Active Work Sheet).
Selected cells and When click on Command bar button in customized toolbar, problem is if there are any formulas in Sheet2, populating data is very slow in Sheet1 and status bar is displaying “Calculating Cells: 100%” for each cell.

Is there any solution to stop calculating cells while populating data in active sheet1 even though there are any formulas in sheet2? Or else disable formulas while populating data?

Any other solution in your mind?

FYI: if I remove sheet2 and do the above process, populating data in Sheet1 is 100% faster than previous.

Please reply to message ASAP.

Thanks in advance.

I'm not a VBA expert, but I think this would work.

Right before populating the data sheet, Execute a statement that sets the EnableCalculation property of the worksheet to FALSE. If I understand correctly, this should prevent Excel from automatically recalculating formulas in that worksheet. After the data sheet is populated, execute another statement to reset the property back to TRUE. You also might have to execute a calculate method on the worksheet to make sure the formulas update after the data are all populated.