Skip to main content
Member
Dec 15, 2022 4:31 AM UTC

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 excel?

 

 

Regards,

Madesh K

4 replies

Employee - Sage
Dec 16, 2022 2:46 PM UTC

I'm not an Excel guru, but I see that there is a https://learn.microsoft.com/en-us/office/vba/api/Excel.Range.AutoFit method in VBA, so you could do it with an Excel macro.

MadeshKAuthor
Member
Dec 16, 2022 3:38 PM UTC

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

OneStream Employee
Feb 20, 2023 5:35 PM UTC

Did you ever get this to work?

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