1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

small file Opens Slowly

Discussion in 'Ask an Excel Question' started by sheter, Mar 9, 2018.

  1. sheter

    sheter Member

    Messages:
    32
    I've been working on a time-sheet file to log-in / log-out of projects we work on each day.

    PROBLEM! The file opens very slowly

    File Size: 661 KB
    Opening time: 28 seconds


    QUESTION: Is there a fix or should I start over?

    Thanks!

    Attached Files:

  2. vletm

    vletm Excel Ninja

    Messages:
    3,590
    sheter
    I tested ... less than 10secs.
    1) Have You tested with 'Calculation-Manual'?
    2) Do Your harddisk has enough space?
    3) There are 'some' calculations
    ... eg 12-times months
    ... do You need all of those? Of course, one needs.
    Chirag R Raval likes this.
  3. sheter

    sheter Member

    Messages:
    32
    Vletm,
    Thank you for testing...I'm starting to wonder if it's our server causing the issue.

    Hahaha >>> "Of course, one needs"

    So can you help me know which calculations are redundant?
  4. vletm

    vletm Excel Ninja

    Messages:
    3,590
    sheter
    ... You just remember that You're using that file from Your server.
    ... that will 'only makes everything slower'.
    Have You tested to open it from Your PC's harddisk?
    Case one needs:
    How many months You could see in one time?
    Chirag R Raval likes this.
  5. vletm

    vletm Excel Ninja

    Messages:
    3,590
    sheter
    I did 'minor modifications'.
    ... like ONE month-sheet and times will be times.
    But, so far, I cannot test it ... I can see many #NAME?.

    Attached Files:

  6. sheter

    sheter Member

    Messages:
    32
    There will need to be separate sheets for each month
  7. vletm

    vletm Excel Ninja

    Messages:
    3,590
    How many months You could see in one time?
    There is 'dropdown' to select month ...
    then those 'Month-sheets' could be any or any order?
    or
    Where? Do that file need or what?
  8. sheter

    sheter Member

    Messages:
    32
    The final version of this file will not have a dropdown in the Month-Sheets. I put it in for testing only. Sorry for the confusion. =(
  9. vletm

    vletm Excel Ninja

    Messages:
    3,590
    If that is ONLY reason ... then You would leave it.
    3rd time... How many months You could see in one time?
  10. sheter

    sheter Member

    Messages:
    32
    I'm sorry Vletm, I'm not sure what you're asking:
    "How many months You could see in one time?"

    The idea I have is for each month to be on it's own separate printable "timesheet" so we can print each month for our records. Currently, the file is not complete...that's why there is only one sheet "JAN".

    I hope this clarifies.
  11. vletm

    vletm Excel Ninja

    Messages:
    3,590
    Okay 4th time -
    "How many months You could see in one time?"
    If You can see only ONE month in time - then You have 'normal monitor'.
    If You can see twelve months in SAME time ...
    then You will need twelve files and twelve monitors.
    Don't those 12 month-sheets have same formulas?

    For 'printing' of those twelve 'timesheets',
    You will need ONE sheet ...
    Jan > print >
    change to Feb > print >
    and so on until
    Dec has printed.

    That 'change' could do automatic ...
    means
    You will press the button and wait until it's ready.

    (same way it would possible to printout eg 10yrs sheets, if there would be data ... no need to have 120 sheets for months)
  12. sheter

    sheter Member

    Messages:
    32
    You will see ONE month at a time.
  13. vletm

    vletm Excel Ninja

    Messages:
    3,590
    Check this DEMO
    Open JAN...DEC
    Press [ PRINT YEAR]
    This shows the whole current year.
    It is possible to add Printing ... PDF ....
    and
    If needs to print 'only' Feb and Jun ... or any combination ... that's possible to.
    That option isn't there now.

    Attached Files:

    Last edited: Mar 9, 2018
  14. sheter

    sheter Member

    Messages:
    32
    Oh wow!!! Very cool! Thank you Vletm!!
  15. vletm

    vletm Excel Ninja

    Messages:
    3,590
    sheter
    I tested to make 'OUTPUT'
    1) select needed YEAR
    2) select needed MONTH
    3) select needed OUTPUT (PRN, PDF) (PDF needs PDF-folder)
    - - - in none of above then it will show month three seconds.
    4) Press [ OUTPUT ]

    Attached Files:

    Chirag R Raval likes this.
  16. vletm

    vletm Excel Ninja

    Messages:
    3,590
    sheter asked: So can you help me know which calculations are redundant?
    I tested in 'Month'-sheet ...
    there are still some formulas left.
    One challenge was that I don't know what would the original layout look.

    Attached Files:

  17. vletm

    vletm Excel Ninja

    Messages:
    3,590
    sheter
    ... continue cleaning that file (from 660kb to ~111kb)
    There are still questions and also some cleaning.

    Attached Files:

  18. vletm

    vletm Excel Ninja

    Messages:
    3,590
    sheter
    ... I would use something like this.

    Attached Files:

  19. vletm

    vletm Excel Ninja

    Messages:
    3,590
    sheter ... I'll try still ...
    I did some checking ... of course there were 'sample data'
    ...but if someone would use this in the real -
    then there could be cases as below
    This would be challenge to notice other ways.
    ... there are 'holes' ... missing hours for some reason.
    If 'only' few minutes will miss, then challenge but
    if there are over hour misses then ... someone won't be happy.
    Screen Shot 2018-03-18 at 19.55.12.png
    If You're still interesting then let me know.

Share This Page