When I am trying to download a dynamic pivot table, it is getting downloaded as a normal excel sheet instead of a pivot table. Please let me know if there is any solution for this? Even I didn't get any dialogue box like to "add columns in Pivot table".

Thanks in Advance!!

Screenshots below: