Professor Excel

Comments 13

  1. John

    Hi, could you fix up the wording of the fifth section so it makes sense please? (5. Same cell ranges in formulas)
    It looks like some words have accidentally been deleted from the paragraph.
    Cheers
    John

  2. Anbuselvam K

    Hi

    Can you please explain more about the section 13. Please send some example file for better understanding to split the one file to several.

  3. Mae Chacon

    Thank you very much and its beautiful page,we liked it.

  4. Mayhem

    Hi

    More often than not volatile formulas, conditional formats and other useful excel features are needed to analyse large data sets. If you stop using the features of excel that make it useful there is no point in using excel. Hence the solution cannot be to stop use the features of excel that makes it useful.

    • Henrik Schiffner

      Hi Mayhem,
      you are right, you should consider well if you want to remove useful and essential features from your Excel workbook. But to my mind, the speeding-up process has several steps: First you need to find out what feature/worksheet/table slows down the calculation. Especially formulas (e.g. lookups) within conditional formatting rules should be evaluated. As the next step you have to decide, if you want to keep that feature and try to optimize less important parts of your workbook. Also you could just temporarily remove or also optimize them. For most features there are alternatives (maybe less beautiful).
      In order to cut a long story short: I still believe you should at least investigate those features you mentioned. Only that way you can make a well considered decision of how to speed up your workbook.
      Best regards,
      Henrik

  5. Miha

    Hello Henrik,

    I have problem also with very slow excel workbook. Can you please be so kind and check what is wrong with this file if I send it to you? I have try almost all your methods. The file is my own product and nobody can explane why is hapening or processing everything so long. Copying of one cell can take to 5 minutes.

    Thank you in advance

    • Henrik Schiffner

      Thanks for the comment. VLOOKUP is not volatile, though, so that it shouldn’t be added to number 11.

Leave a comment