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.