+ Reply to Thread
Results 1 to 12 of 12

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

  1. #1
    Registered User
    Join Date
    07-01-2018
    Location
    Houston, TX.
    MS-Off Ver
    Office 365
    Posts
    55

    Post 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

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    2007
    Posts
    4,008

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

    .
    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.

  3. #3
    Registered User
    Join Date
    07-01-2018
    Location
    Houston, TX.
    MS-Off Ver
    Office 365
    Posts
    55

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

    I will try, thanks

  4. #4
    Registered User
    Join Date
    07-01-2018
    Location
    Houston, TX.
    MS-Off Ver
    Office 365
    Posts
    55

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

    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.

  5. #5
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    2007
    Posts
    4,008

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

    .
    Curious that adding ActiveX Labels would increase load time.

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

  6. #6
    Registered User
    Join Date
    07-01-2018
    Location
    Houston, TX.
    MS-Off Ver
    Office 365
    Posts
    55

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

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

  7. #7
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    2007
    Posts
    4,008

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

    .
    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.

  8. #8
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    2016 Win10
    Posts
    6,743

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

    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.

  9. #9
    Registered User
    Join Date
    07-01-2018
    Location
    Houston, TX.
    MS-Off Ver
    Office 365
    Posts
    55

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

    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

  10. #10
    Registered User
    Join Date
    07-01-2018
    Location
    Houston, TX.
    MS-Off Ver
    Office 365
    Posts
    55

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

    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,

  11. #11
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    2016 Win10
    Posts
    6,743

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

    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.

  12. #12
    Registered User
    Join Date
    07-01-2018
    Location
    Houston, TX.
    MS-Off Ver
    Office 365
    Posts
    55

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

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1