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.
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.
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.
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.
Thanks for prompt reply, will give it try.
Awesome bro
Thanks bro!
I'd like to automate daily reports and set it on a timmer to be sent example : 7 am to the desired email.
Very nice
Thank you.
You said you will create dashboard...waiting.Will be very helpful