Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
im working with pivot table and i need to export Excel. While exports to a limited extent, but when you pass a certain number of columns, exports comma separated data. Ej. I have 14 dimensions and 1 Expression and works fine, but when add a dimension, export comma separated data.
Any sugestion?
Thanks
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.