additional activeX added WB takes approx. 34 sec. to be ready, determine cause.

I have a normal WB with 12 months + a couple extra sheets that i use for data and settings, file size ~365k, ready to use ~ 7sec. I am adding functionality, and have added 25 activeX labels(they LOOK better than buttons) per sheet(Jan-Dec), file size now ~728k. The workbook now takes ~ 34 seconds for ready to use.

How can I determine what is causing this delay ?, I can post a copy if needed.

Win 10 64bit, Office 365 64bit

.
If you haven't already done so, try saving the workbook as .XLSB format.

It should reduce the overall size and hopefully speed things up.

I will try, thanks

change in file size minimal, origional xlsm = 728k , binary 699k, no reduction in time.

I understand it could be any number of things, I do not have any odd add-on's loading, a very little data. it could just be a Excel thing. just trying for better.

.
Curious that adding ActiveX Labels would increase load time.

Did you also add additional data to the workbook ? Additional records ?

no added data or records, Using a mostly empty workbook because it's Jan.

.
I replicated the same thing here by adding 25 ActiveX labels. The size of the workbook grew exponentially and the time required to open the workbook
increased substantially as well.

I am not certain there is anything you can do the change this if you continue to use ActiveX labels.

Sorry.

You're better off not using ActiveX controls on worksheets at all. They're incredibly unstable have a look here https://www.google.co.uk/webhp?sourc...eet%20controls and by using them, you're asking for trouble.

Forms controls are much more reliable - they're in the same dropdown as the ActiveX ones, but are designed for use on worksheets - so you don't run into any stability issues, you can do most of the same things with them too and you can use them without using code.

ok, haven't thought of that approach, I will change the activeX labels to the Form Control label. this may take a day due to my scheduling - but I will post a followup.

thanks for the input

initial testing has showed,
I am not able to format, color, or have other properties available using Form Controls, also It appears I am unable to pass a value to a sub. In order to maintain consistency throughout my code/Workbook I must use ActiveX controls as they are the only controls available for use on a Sheet as well as a User Form.

I will leave this open for another day or so for additional suggestions,

You can pass values using application.caller and reference the closest cell.

If you want to change colours etc, just use a shape and format it appropriately, you can still assign a macro in the same way as a forms control.

Thank you for the help, I have somehow trimmed the "ready to go" time by 10 seconds, 34 down to 24, still not the desired outcome. when I complete the bulk of logic code I will again "play" with shapes/forms controls.