![]() ![]() A little bit contradicting: But not being able to include VBA macros can be an advantage and disadvantage at the same time.Can use and save all the functions available in Excel.Secure because it can’t save VBA macros.Uses the open file format and is in general accessible with other applications.The default file format and because of that the best known and widest spread file type.Knowing these quick facts, there are the following advantages and disadvantages for the XLSX file format: Advantages It uses the open XML standard so which is documented well. Most of the time you use the XLSX format: It’s save (can’t store malicious code), has the maximum number of rows and columns and is best known. XLSX is available since Excel 2007 and replaces the old XLS file type. Cannot store Microsoft Visual Basic for Applications (VBA) macro code. The default XML-based file format for Excel 2007-2013. Microsoft says in the Excel help text about the XLSX file format: The large majority of Excel workbooks uses this format these days. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |