Forum Discussion

MadeshK's avatar
MadeshK
New Contributor
3 years ago

Excel Column autofit while opening cubeview in excel via cubeview connections

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...
Cube View
Excel Add In
JackLacava's avatar
JackLacava
Honored Contributor
3 years ago

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's avatar
    MadeshK
    New Contributor
    3 years ago

    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's avatar
      RobDessureault
      Contributor II
      2 years ago

      Did you ever get this to work?

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

       

      • MadeshK's avatar
        MadeshK
        New Contributor
        2 years ago

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