Excel Column autofit while opening cubeview in excel via cubeview connections

[MadeshK]

Hi, 
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?

Regards,

Madesh K

[JackLacava]

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.

[MadeshK]

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

[RobDessureault]

Did you ever get this to work?

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

[MadeshK]

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