the dot xls file type was replaced with xlsx from excel NUMBER_TOKEN onward however many third-party systems still have an option to export data to xls URL_TOKEN files are based on the binary interchange file format or bif for short and they store information in a binary format whereas dot xlsx files are based on office open xml format that stores data in compressed xml files in a zip format for example if we take a look at this file here and open it with zip software so i'm going to open the archive and if i click on excel you can see the different components and settings that make up this file now if you open a xls file in versions of excel from NUMBER_TOKEN onward you will still have access to the up-to-date functionality however you're going to be limited to NUMBER_TOKEN NUMBER_TOKEN rows and NUMBER_TOKEN columns xls also doesn't support auto-save and macros are able to be saved in this file format which makes it less secure than the newer xlsm file format which has more robust security plus when you try to save this file you're going to get bombarded with a load of compatibility warnings that are super annoying so the solution is to make a copy of this file and change the file format to xlsx i hope you found this video helpful you can download the file for this lesson from the link here and you'll find links to all the tutorials mentioned in the video description and if you like this video please give it a thumbs up and subscribe to our channel for more and why not share it with your friends who might also find it useful thanks for watching
START_INTERACTION_TOKEN found this video helpful you can download the file for this lesson from the link here and you'll find links to all the tutorials mentioned in the video description and if you like this video please give it a thumbs up and subscribe to our channel for more and why not share it with your friends who might also find it useful thanks for watching END_INTERACTION_TOKEN