Professor Excel

Comments 6

  1. Foster

    Wonderful information on Excel. It answered many questions I have had for a long time and didn’t know where to find the answers. You pulled a lot on information together in a succinct presentation. Thanks Much!!!

    • Henrik Schiffner

      Hi Foster,
      Thanks for the reply. I’m glad it has helped you!
      Best regards,

  2. Mark

    I am surprised that your pros/cons don’t list any performance issues with binary files. I can’t have any large pivot tables in a binary file or it freezes up.

    • Henrik Schiffner

      Thanks for the feedback, Mark. Does this always happen to you working in the xlsb file format? I haven’t noticed any issues – at least not more than in the xlsx or other file formats.

  3. Bloodknot

    You need to check what you are telling people

    “Excel suggests the XLSX file type (unless your file doesn’t have VBA macros)” is misleading.

    “Can only use up to 65,536 (2^16) rows and 256 (2^8) rows.” is just wrong.

    • Henrik Schiffner

      Hi Bloodknot,

      Thanks for the feedback. Please provide any proof for your accusations.
      What do you mean with misleading? I suppose you refer to the sentence “By default, Excel suggests the XLSX file type (unless your file doesn’t have VBA macros).” That’s exactly what happens when you save a new Excel file.
      And concerning the second part: What is wrong about it? It refers to the “XLS” file format. Please try it yourself: Save an Excel file as .xls, close Excel, open the file again and scroll to the right bottom corner. What is the maximum row number there? What is the maximum column?

      I’m always happy about feedback and would gladly correct inaccurate information. So please provide any kind of evidence or proof supporting your comments.

      Thanks and best regards,

Leave a comment

%d bloggers like this: