ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   In excel what does a file ending with .xlsx mean? (https://www.excelbanter.com/excel-discussion-misc-queries/223088-excel-what-does-file-ending-xlsx-mean.html)

pdog1967

In excel what does a file ending with .xlsx mean?
 
I have created and saved several files in Excel. I then sent them to a friend
at a different company. I was then notified that they could open all of the
files that were .xls but the one that was .xlsx they could not open. How did
I get the file saved with the extra x, and what does that mean?

PJFry

In excel what does a file ending with .xlsx mean?
 
..xlsx is a Excel 2007 format, whereas .xls is Excel 2003 or earlier.

Excel 2007 allows you to save in multiple 2007 formats:
..xlsx - Normal Excel 2007 format
..xlsm - Macro-Enabled format
..xlsb - Binary format

Save your files as 2003 under Save as Type and you should be fine.

PJ

"pdog1967" wrote:

I have created and saved several files in Excel. I then sent them to a friend
at a different company. I was then notified that they could open all of the
files that were .xls but the one that was .xlsx they could not open. How did
I get the file saved with the extra x, and what does that mean?


Ron de Bruin

In excel what does a file ending with .xlsx mean?
 
Hi pdog1967

This is one of the new file formats in excel 2007

See
http://www.rondebruin.nl/2007filesin2003.htm

This are the main formats in Excel 2007 :

xlsx = xlOpenXMLWorkbook (without macro's in 2007, xlsx)
xlsm = xlOpenXMLWorkbookMacroEnabled (with or without macro's in 2007, xlsm)
xlsb = xlExcel12 (Excel Binary Workbook in 2007 with or without macros, xlsb)
xls = xlExcel8 (97-2003 format in Excel 2007, xls)


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"pdog1967" wrote in message ...
I have created and saved several files in Excel. I then sent them to a friend
at a different company. I was then notified that they could open all of the
files that were .xls but the one that was .xlsx they could not open. How did
I get the file saved with the extra x, and what does that mean?



pdog1967

In excel what does a file ending with .xlsx mean?
 
Thanks, I thought that I had saved them all the same, guess not.

"PJFry" wrote:

.xlsx is a Excel 2007 format, whereas .xls is Excel 2003 or earlier.

Excel 2007 allows you to save in multiple 2007 formats:
.xlsx - Normal Excel 2007 format
.xlsm - Macro-Enabled format
.xlsb - Binary format

Save your files as 2003 under Save as Type and you should be fine.

PJ

"pdog1967" wrote:

I have created and saved several files in Excel. I then sent them to a friend
at a different company. I was then notified that they could open all of the
files that were .xls but the one that was .xlsx they could not open. How did
I get the file saved with the extra x, and what does that mean?



All times are GMT +1. The time now is 06:37 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com