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