Hi all,

I recently created a template for reconcilliation.

The problem with this template is that the calculation take so *%@#(*#%(* long!

This is what i do:
I paste 3 (pretty big) excel files in the template, each in different sheets.
With formulas i calculate values which i later consolidate in 3 Pivot Tables.

I just tried the template and it works, but it had to calculate for like half an hour and i would like to speed it up.

Is there any way to speed this process up? Maybe with various VBA scripts?
What are your experiences?

Regards,
Crispy85