D
Deleted member 7160
When you save all excel file in binary format which .xlsb it keeps all your pivot table, macros & conditional formating. In short everything what .xlsx will have. I have been saving all my excel files with macros and pivot tables in .xlsb.