There are many cases when the IBP icon in excel got disable and need to enable everytime manually.
Also, macro-enable reports are taking way too long time which ends up in session expire...in this case changing the layout option will work ?
Or is there any other workaround for this ?
Yes Irmh, I meant with the IBP excel Add-on.
I will follow the process mentioned by Rinju...and agree with the Anna response as well that incase of crash and after restart if we select the option of disable then it will get disable and will require manual enabling.
Regarding the second query...I will get back with more information.
I also don't understand the second part of the question (so as mentioned by Irmi, some more info would be good), but as for the first part with the add-in being disabled, I have experienced this also once.
This happens when an error occurs and excel crashes. After restarting the Excel it asks to disable the IBP add-in because of the previously encountered error. When I clicked disable, it continuously disabled the add-in every time I started excel again.
This is some Microsoft functionality that I also did not find a solution for. However, uninstalling and re-installing the add-in solved the issue for good.
Lessons learnd: Never press "disbale add-In" when you are asked...
Is this the same situation that you were facing? Or is this happening independently from this?
I think I dont understand your request:
- what is the "IBP icon" ? Do you mean the ribbon disappear that comes with the addon?
- what kid of macros are you working with, maunally written VBA? recorded VBA? Others? I never experienced a time out when using VBA - macros as long as they are written properly
- why do you think change of layout would improve performance, did you test that? Can you share some screenshots? Would be interesting, for me it never did a measurable difference
And can you share the macros?
- do you work with charts?