Types of Microsoft Excel File Extensions

Microsoft Excel is software Developed by Microsoft which allows user to organise, calculate an format data with the help of various formulas using spreadsheet system.It is a part MS-Office suit and is compatible with other applications of MS-Office.With the Evolution of computers and technology Microsoft also evolved its products including ms excel for security, ease of doing things for the sake of user.Lets talk about the journey of ms excel, it’s evolution and advantages and disadvantages of each versions.

1) Microsoft XLSX File

The default version of ms-excel file used these days.It is more secured than the previous versions of excel and has the maximum numbers of row and columns.It came after 2007 and replaces the old Xls file type.

Advantages
a) The default file format and because of that the best known and widest spread file type.
b) Can use up to 2^20 (1048576) rows and 2^14 (=16384) columns.
c) Uses the open file format and is in general accessible with other applications.
d) Secure because it doesn’t save VBA macros.
e) Can use and save all the functions available in Excel.

Disadvatages

a) Needs more disk space than other file formats .
b) Cannot be opened with versions before ms excel 2003.

2)Microsoft XLS

It was the default excel file extension before excel 2007.Replaced by XLSX in 2007.It is not safe as it’s password can be cracked easily but still used by many.

Advantages
a) Can be opened with version before excel 2007.

Disadvatages
a) Unsafe as it can contain VBA macros.
b)Can’t use all newer Excel functions, e.g. formulas or functionality
d)Can only use up to 65,536 (2^16) rows and 256 (2^8) rows.

Posts created 17

7 thoughts on “Types of Microsoft Excel File Extensions

  1. whoah this blog is great i love reading your posts. Keep up the great work! You know, many people are searching around for this information, you could aid them greatly.

  2. Hey very nice web site!! Man .. Beautiful .. Amazing .. I will bookmark your I’m happy to find a lot of useful info here in the post, we need develop more strategies in this regard, thanks for sharing. . . . . .

  3. Hi there would you mind stating which blog platform you’re working with? I’m looking to start my own blog in the near future but I’m having a hard time deciding between BlogEngine/Wordpress/B2evolution and Drupal. The reason I ask is because your design seems different then most blogs and I’m looking for something completely unique. P.S Apologies for getting off-topic but I had to ask!

  4. I have been exploring for a bit for any high quality articles or blog posts on this kind of area . Exploring in Yahoo I at last stumbled upon this site. Reading this information So i抦 happy to convey that I have a very good uncanny feeling I discovered just what I needed. I most certainly will make certain to don抰 forget this website and give it a glance on a constant basis.

Leave a Reply

Your email address will not be published. Required fields are marked *

Related Posts

Begin typing your search term above and press enter to search. Press ESC to cancel.

Back To Top