12-14-2022 11:31 PM
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
12-16-2022 09:46 AM - edited 12-16-2022 09:47 AM
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.
12-16-2022 10:38 AM
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
02-20-2023 12:35 PM
Did you ever get this to work?
I'm trying to do the same, but can't find any functionality to do it.
02-20-2023 08:56 PM
No, we didn't get any workaround for this.