Excel Column autofit while opening cubeview in excel via cubeview connections

New Contributor

We are having a requirement to pull the cubeview in excel. While pulling the cubeview the coulmns are not autofit.

Is there a way or workaround for doing the autofit while opening cubeview in excel?




Madesh K


Community Manager
Community Manager

I'm not an Excel guru, but I see that there is a Range.Autofit() method in VBA, so you could do it with an Excel macro.

Hi Jack,

Thank you for your reply. Actually we were trying to do it when opening the cube view in excel.

Thanks & Regards,

Madesh K

Did you ever get this to work?

I'm trying to do the same, but can't find any functionality to do it.


No, we didn't get any workaround for this.