Hi all,

i always receive 200 mb file.
which i has, around 10 sheets , with pivot tables and formulas.

i have to open this file update refresh and save as this file, which i am doing via vba.

however the challenge for me here is though i set xl calculation to manual at the begining and xl calculation to automatic at the end.
Though i used this code, its taking close to 5 mins to complete this via Vba.

how or what is the alternate way to reduce.

help and suggestions is really needed.