• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Exportasfixedformat in excel 2013 is 3 times slower then previous versions

S

samv

New Member
Hi,

I use ExportAsFixedFormat to save my worksheet in a pdf, using vba code, in excel2013.
Now it runs 3 times longer then in an older version of excel.
Can I fix this ?

Thanks !
 
Its either that your file is too big - because of data or pivots or conditional formats / OR you've got too many formulas in your file so each time something is changed by your vba the formulas recalculate & it takes longer to do its thing. But can't really give u a 100% answer till I know what the code is & which file it works on. No way to know for sure.
 
You must log in or register to reply here.
Back
Top