Pausing formula in name manager

Hi,

I have a large workbook which uses VBA to import data.

As the workbook has grown through time into a frankenstein the speed at which this import happens has fallen dramatically (10 seconds taking nearly 10 minutes). My old method of fixing this would be to use VBA to convert CPU/memory intensive formulas into values which alwas seemed to work. The workbook is still fast (or appears so) because of using values, but when VBA is running it's very slow...

I think this because there are so many graphs in dashboards which use the name manager to be "dynamic" that when VBA is running this is slowing it down. I think the because If I go into the name manager and delete everything then it's as quick as ever.

My question is - can you disable everything in the name manager while VBA is running and then turn it back on after? I can't be sure but I'd be confident this would solve my problem.

Thanks for your time

Hey Kaper,

Thanks for the reply. It's still slow using your code. Is your method any different to having:

application.calculation = xlmanual

I already have that in the code

Best regards,
Sean

Sorry Kaper I meant no offence, I wasn't too clear in my explaination

So you can change the formulas in the name manager in VBA? That would probably solve it. Deleting them isn't an option for me

This is genius!!

I've only just got enough time at work to try this out. Works an absolute charm! Thank you Kaper