Why so slow and can it be improved?

Hi,

im in the middle of creating an IO schedule to crunhc through 1k or so lines of IO. as i add to the functionality it increases to become slower and slower as it calcs. it currenlty now calculates what looks like a in a loop 3 times. i appreciate it may not be the most efficiently produced workbook but can anyone help me to improve this or pint out where im going massively wrong?

Thanks

Thanks very much for doing that, I've not tried this yet but everything you said makes absolute sense... Thanks again

Originally Posted by Whizbang

Took me all day to be able to post this on the forum. Yeesh.

You can optimize your code like the below. In VBA you usually don't need to select an item to work with it, or even have it visible.

Please Login or Register  to view this content.

To make your file size smaller, you can make all your pivot tables have the same Data Source. Pivot Tables, by default, store their data in the background. It is not just a reference. Pivot Tables are smart(ish), though and when two or more Pivot Tables share the same data source, it will only store the data once. If the sources are at all different, however, you are duplicating data. So, as a best practice, when possible, just grab the whole table for all your pivot tables and then only display the columns you need.

I don't know what else can be done to speed up the workbook.