Automate daily reporting in Excel using Pivot Tables

[@anandchawda7061]

Thanks very useful and helpful. I tried Data1 to adjust pivots automatically every time I add new data however it does not take source as Data1 when I tried to change source, it gives an error reference isn't valid. I also have table 1 in data manager which is the current reference. Any tips on that will be appreciated.

[@LearnAccountingFinance]

Try copying the source data into a new excel file and following all steps again. Happens sometimes when one of the steps is not done correctly. Creating a fresh excel file and doing all over again is a faster solution.

[@BollywoodBlissCouple]

Thanks for prompt reply, will give it try.

[@MUAISC]

Awesome bro

[@LearnAccountingFinance]

Thanks bro!

[@jinkss111]

I'd like to automate daily reports and set it on a timmer to be sent example : 7 am to the desired email.

[@shaileshjha6623]

Very nice

[@LearnAccountingFinance]

Thank you.

[@ushakiran3577]

You said you will create dashboard...waiting.Will be very helpful