Large file taking much time to save or open

**prabhuduraraj09** · 03-29-2014, 08:43 AM

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:

**HaHoBe** · 03-30-2014, 03:00 AM

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