im working with pivot table and i need to export Excel. Whileexportsto a limited extent, butwhen you passa certainnumberof columns, exportscomma separateddata. Ej. I have 14 dimensions and 1 Expression and works fine, but when add a dimension, export comma separated data.
I think that's because of backward compatibility with older excel versions that can only handle 256 columns. If your pivot table exceeds this number the export format will change to csv.