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.
Hi, prabhuduraraj09,
if you turn on Calculation at the end of the macro Excel will do exactly that - calculate. You would need to turn it off prior to opening the file, when being turned on or the file being saved calculation is taking place.
Maybe you could post the code to look at - the common things are ScreenUpdating, EnableEvents and Calculation to speed the code up but maybe some of your code may be shortened/streamlinied for faster execution.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Hi HaHoBe,
you are my favourite always...........hope you remember me. Thanks for showing up, i am glad you are here...........
About the Code below is the example, but the original code..........its in office
Yes HaHoBe, i would really glad if you could help in stream line this code.........Since im not an expert......
i managed to put together many action codes together on my own.....Really. I thought who would really help me in steam lining.............
If you could really help me in stream lining the code.........That would be great. For sure i could submit on Monday.
And will you sure......have check on my message. or is there any other way....could send the codes directly to you for review.
Would be really glad , if this code can be stream lined for better performance.
HTML Code:
Hi, prabhuduraraj09,
if you open a woirkbookand want to refresh pivots in that workbook it´s not ThisWorkbook (which is the workbook with the code) but ActiveWorkbook (as that workbook would be the last one being opened). Waiting for the full code to have a look at.
Ciao,
Holger
Hi Hahobe,
Please find the attached file with codes.
This is what i was talking about to get streamlined.
Hope you would help me in sorting this
Last edited by prabhuduraraj09; 04-05-2014 at 07:00 AM. Reason: incorrect attachment
Hi, prabhuduraraj09,
as I do not have the files to test this is untested and needs your test (this is only the start of the macro but shows how to go on):
Ciao,
Please Login or Register to view this content.
Holger
Hi HaHobe,
im not an expert, but will give a try to shrink every codes............
Not sure how good.......
will let you know know incase i face error.......
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks