Skip to main content
M
MadeshK
Newcomer
December 15, 2022

Excel Column autofit while opening cubeview in excel via cubeview connections

  • December 15, 2022
  • 1 reply
  • 0 views

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

1 reply

J
OneStream Employee
JackLacavaOneStream Employee
OneStream Employee
December 16, 2022

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.

M
MadeshKAuthor
Newcomer
December 16, 2022

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

R
OneStream Employee
RobDessureaultOneStream Employee
OneStream Employee
February 20, 2023

Did you ever get this to work?

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

 

Terms & ConditionsAccessibility statement