| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to default file save format to .xlsx in Excel?
I tried to change the file save format under Excel Options to .xlsx but it
only works on the current session. Once I close out and reopen, it switched back to .xls. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to default file save format to .xlsx in Excel?
I thought that XLSX is the default format for Excel 2007.
How are you saving? If you open an XLS file then it will be saved in the same format unless you choose SAVE AS "Carina" wrote: I tried to change the file save format under Excel Options to .xlsx but it only works on the current session. Once I close out and reopen, it switched back to .xls. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to default file save format to .xlsx in Excel?
No. For some reason the default on my Excel 2007 is .xls. I can do file save
as or convert to .xlsx but it is annoying that everytime when i open up a new excel session, i can only see 65,000 rows and in compatible mode. "Sheeloo" wrote: I thought that XLSX is the default format for Excel 2007. How are you saving? If you open an XLS file then it will be saved in the same format unless you choose SAVE AS "Carina" wrote: I tried to change the file save format under Excel Options to .xlsx but it only works on the current session. Once I close out and reopen, it switched back to .xls. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to default file save format to .xlsx in Excel?
No. For some reason, my excel 2007 default is .xls. I know i can do save as
or convert to .xlsx but it is annoying that everytime when i open up a new session, i can only see 65,000 rows and in compatible mode. "Sheeloo" wrote: I thought that XLSX is the default format for Excel 2007. How are you saving? If you open an XLS file then it will be saved in the same format unless you choose SAVE AS "Carina" wrote: I tried to change the file save format under Excel Options to .xlsx but it only works on the current session. Once I close out and reopen, it switched back to .xls. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to default file save format to .xlsx in Excel?
Are you saying that even if you create a new workbook and save it for the
first time, it gets saved as XLS? Pl. confirm. Also describe the steps you take to save... "Carina" wrote: No. For some reason, my excel 2007 default is .xls. I know i can do save as or convert to .xlsx but it is annoying that everytime when i open up a new session, i can only see 65,000 rows and in compatible mode. "Sheeloo" wrote: I thought that XLSX is the default format for Excel 2007. How are you saving? If you open an XLS file then it will be saved in the same format unless you choose SAVE AS "Carina" wrote: I tried to change the file save format under Excel Options to .xlsx but it only works on the current session. Once I close out and reopen, it switched back to .xls. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to default file save format to .xlsx in Excel?
Correct, when i save it for the first time it gets saved to .xls. I have to
remember to save the file type as .xlsx everytime when i create a new excel file. "Sheeloo" wrote: Are you saying that even if you create a new workbook and save it for the first time, it gets saved as XLS? Pl. confirm. Also describe the steps you take to save... "Carina" wrote: No. For some reason, my excel 2007 default is .xls. I know i can do save as or convert to .xlsx but it is annoying that everytime when i open up a new session, i can only see 65,000 rows and in compatible mode. "Sheeloo" wrote: I thought that XLSX is the default format for Excel 2007. How are you saving? If you open an XLS file then it will be saved in the same format unless you choose SAVE AS "Carina" wrote: I tried to change the file save format under Excel Options to .xlsx but it only works on the current session. Once I close out and reopen, it switched back to .xls. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to default file save format to .xlsx in Excel?
Do you have a file named BOOK.xlt in your XLSTART folder lefy over from an
earlier version of Excel? When I installed 2007 after 2003, 2007 used the BOOK.xlt I had stored for 2003. Consequently all new workbooks in 2007 were 2003 mode. I had to remove BOOK.xlt from the XLSTART folder in order to get the 2007 default workbook. Gord Dibben MS Excel MVP On Fri, 6 Feb 2009 13:08:02 -0800, Carina wrote: Correct, when i save it for the first time it gets saved to .xls. I have to remember to save the file type as .xlsx everytime when i create a new excel file. "Sheeloo" wrote: Are you saying that even if you create a new workbook and save it for the first time, it gets saved as XLS? Pl. confirm. Also describe the steps you take to save... "Carina" wrote: No. For some reason, my excel 2007 default is .xls. I know i can do save as or convert to .xlsx but it is annoying that everytime when i open up a new session, i can only see 65,000 rows and in compatible mode. "Sheeloo" wrote: I thought that XLSX is the default format for Excel 2007. How are you saving? If you open an XLS file then it will be saved in the same format unless you choose SAVE AS "Carina" wrote: I tried to change the file save format under Excel Options to .xlsx but it only works on the current session. Once I close out and reopen, it switched back to .xls. |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to default file save format to .xlsx in Excel?
No, I don't have BOOK.xlt under XLSTART folder. The only file in this folder
is pdfmaker.xla "Gord Dibben" wrote: Do you have a file named BOOK.xlt in your XLSTART folder lefy over from an earlier version of Excel? When I installed 2007 after 2003, 2007 used the BOOK.xlt I had stored for 2003. Consequently all new workbooks in 2007 were 2003 mode. I had to remove BOOK.xlt from the XLSTART folder in order to get the 2007 default workbook. Gord Dibben MS Excel MVP On Fri, 6 Feb 2009 13:08:02 -0800, Carina wrote: Correct, when i save it for the first time it gets saved to .xls. I have to remember to save the file type as .xlsx everytime when i create a new excel file. "Sheeloo" wrote: Are you saying that even if you create a new workbook and save it for the first time, it gets saved as XLS? Pl. confirm. Also describe the steps you take to save... "Carina" wrote: No. For some reason, my excel 2007 default is .xls. I know i can do save as or convert to .xlsx but it is annoying that everytime when i open up a new session, i can only see 65,000 rows and in compatible mode. "Sheeloo" wrote: I thought that XLSX is the default format for Excel 2007. How are you saving? If you open an XLS file then it will be saved in the same format unless you choose SAVE AS "Carina" wrote: I tried to change the file save format under Excel Options to .xlsx but it only works on the current session. Once I close out and reopen, it switched back to .xls. |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to default file save format to .xlsx in Excel?
Sure you got the correct XLSTART folder?
You will have more than one. The default for Excel's BOOK.xlt is C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART Gord On Fri, 6 Feb 2009 20:37:40 -0800, Carina wrote: No, I don't have BOOK.xlt under XLSTART folder. The only file in this folder is pdfmaker.xla "Gord Dibben" wrote: Do you have a file named BOOK.xlt in your XLSTART folder lefy over from an earlier version of Excel? When I installed 2007 after 2003, 2007 used the BOOK.xlt I had stored for 2003. Consequently all new workbooks in 2007 were 2003 mode. I had to remove BOOK.xlt from the XLSTART folder in order to get the 2007 default workbook. Gord Dibben MS Excel MVP On Fri, 6 Feb 2009 13:08:02 -0800, Carina wrote: Correct, when i save it for the first time it gets saved to .xls. I have to remember to save the file type as .xlsx everytime when i create a new excel file. "Sheeloo" wrote: Are you saying that even if you create a new workbook and save it for the first time, it gets saved as XLS? Pl. confirm. Also describe the steps you take to save... "Carina" wrote: No. For some reason, my excel 2007 default is .xls. I know i can do save as or convert to .xlsx but it is annoying that everytime when i open up a new session, i can only see 65,000 rows and in compatible mode. "Sheeloo" wrote: I thought that XLSX is the default format for Excel 2007. How are you saving? If you open an XLS file then it will be saved in the same format unless you choose SAVE AS "Carina" wrote: I tried to change the file save format under Excel Options to .xlsx but it only works on the current session. Once I close out and reopen, it switched back to .xls. |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to default file save format to .xlsx in Excel?
Click Office Button, Excel Options, Save, and change it to .xlsx
Carina wrote: No. For some reason the default on my Excel 2007 is .xls. I can do file save as or convert to .xlsx but it is annoying that everytime when i open up a new excel session, i can only see 65,000 rows and in compatible mode. "Sheeloo" wrote: I thought that XLSX is the default format for Excel 2007. How are you saving? If you open an XLS file then it will be saved in the same format unless you choose SAVE AS "Carina" wrote: I tried to change the file save format under Excel Options to .xlsx but it only works on the current session. Once I close out and reopen, it switched back to .xls. |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to default file save format to .xlsx in Excel?
Gord, Thanks for your replys. I checked under the path that you provided.
There aren't any files inside. I also did a search for "XLSTART" I have 2 hits under C:\Program Files\Microsoft Offices\Office 11 and Office 12 ( that's where i initially checked but no book.xlt). So, I search "Book.xlt" under c:\ drive but no hit. Where else could it be? "Gord Dibben" wrote: Sure you got the correct XLSTART folder? You will have more than one. The default for Excel's BOOK.xlt is C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART Gord On Fri, 6 Feb 2009 20:37:40 -0800, Carina wrote: No, I don't have BOOK.xlt under XLSTART folder. The only file in this folder is pdfmaker.xla "Gord Dibben" wrote: Do you have a file named BOOK.xlt in your XLSTART folder lefy over from an earlier version of Excel? When I installed 2007 after 2003, 2007 used the BOOK.xlt I had stored for 2003. Consequently all new workbooks in 2007 were 2003 mode. I had to remove BOOK.xlt from the XLSTART folder in order to get the 2007 default workbook. Gord Dibben MS Excel MVP On Fri, 6 Feb 2009 13:08:02 -0800, Carina wrote: Correct, when i save it for the first time it gets saved to .xls. I have to remember to save the file type as .xlsx everytime when i create a new excel file. "Sheeloo" wrote: Are you saying that even if you create a new workbook and save it for the first time, it gets saved as XLS? Pl. confirm. Also describe the steps you take to save... "Carina" wrote: No. For some reason, my excel 2007 default is .xls. I know i can do save as or convert to .xlsx but it is annoying that everytime when i open up a new session, i can only see 65,000 rows and in compatible mode. "Sheeloo" wrote: I thought that XLSX is the default format for Excel 2007. How are you saving? If you open an XLS file then it will be saved in the same format unless you choose SAVE AS "Carina" wrote: I tried to change the file save format under Excel Options to .xlsx but it only works on the current session. Once I close out and reopen, it switched back to .xls. |
|
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to default file save format to .xlsx in Excel?
One more try then I'm out of ideas.
Office ButtonExcel OptionsAdvancedGeneralAt start up, open all files in: Do you have a path entered? If so, do you have a blank workbook.xls stored in that folder? Move it out and/or delete the path in the dialog box, which I always do with any version of Excel. Gord On Mon, 9 Feb 2009 09:03:02 -0800, Carina wrote: Gord, Thanks for your replys. I checked under the path that you provided. There aren't any files inside. I also did a search for "XLSTART" I have 2 hits under C:\Program Files\Microsoft Offices\Office 11 and Office 12 ( that's where i initially checked but no book.xlt). So, I search "Book.xlt" under c:\ drive but no hit. Where else could it be? "Gord Dibben" wrote: Sure you got the correct XLSTART folder? You will have more than one. The default for Excel's BOOK.xlt is C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART Gord On Fri, 6 Feb 2009 20:37:40 -0800, Carina wrote: No, I don't have BOOK.xlt under XLSTART folder. The only file in this folder is pdfmaker.xla "Gord Dibben" wrote: Do you have a file named BOOK.xlt in your XLSTART folder lefy over from an earlier version of Excel? When I installed 2007 after 2003, 2007 used the BOOK.xlt I had stored for 2003. Consequently all new workbooks in 2007 were 2003 mode. I had to remove BOOK.xlt from the XLSTART folder in order to get the 2007 default workbook. Gord Dibben MS Excel MVP On Fri, 6 Feb 2009 13:08:02 -0800, Carina wrote: Correct, when i save it for the first time it gets saved to .xls. I have to remember to save the file type as .xlsx everytime when i create a new excel file. "Sheeloo" wrote: Are you saying that even if you create a new workbook and save it for the first time, it gets saved as XLS? Pl. confirm. Also describe the steps you take to save... "Carina" wrote: No. For some reason, my excel 2007 default is .xls. I know i can do save as or convert to .xlsx but it is annoying that everytime when i open up a new session, i can only see 65,000 rows and in compatible mode. "Sheeloo" wrote: I thought that XLSX is the default format for Excel 2007. How are you saving? If you open an XLS file then it will be saved in the same format unless you choose SAVE AS "Carina" wrote: I tried to change the file save format under Excel Options to .xlsx but it only works on the current session. Once I close out and reopen, it switched back to .xls. |
|
#13
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to default file save format to .xlsx in Excel?
Gord, I don't have a path entered under the below. I guess we really ran out
ideas. At least we tried. Thanks for your help! "Gord Dibben" wrote: One more try then I'm out of ideas. Office ButtonExcel OptionsAdvancedGeneralAt start up, open all files in: Do you have a path entered? If so, do you have a blank workbook.xls stored in that folder? Move it out and/or delete the path in the dialog box, which I always do with any version of Excel. Gord On Mon, 9 Feb 2009 09:03:02 -0800, Carina wrote: Gord, Thanks for your replys. I checked under the path that you provided. There aren't any files inside. I also did a search for "XLSTART" I have 2 hits under C:\Program Files\Microsoft Offices\Office 11 and Office 12 ( that's where i initially checked but no book.xlt). So, I search "Book.xlt" under c:\ drive but no hit. Where else could it be? "Gord Dibben" wrote: Sure you got the correct XLSTART folder? You will have more than one. The default for Excel's BOOK.xlt is C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART Gord On Fri, 6 Feb 2009 20:37:40 -0800, Carina wrote: No, I don't have BOOK.xlt under XLSTART folder. The only file in this folder is pdfmaker.xla "Gord Dibben" wrote: Do you have a file named BOOK.xlt in your XLSTART folder lefy over from an earlier version of Excel? When I installed 2007 after 2003, 2007 used the BOOK.xlt I had stored for 2003. Consequently all new workbooks in 2007 were 2003 mode. I had to remove BOOK.xlt from the XLSTART folder in order to get the 2007 default workbook. Gord Dibben MS Excel MVP On Fri, 6 Feb 2009 13:08:02 -0800, Carina wrote: Correct, when i save it for the first time it gets saved to .xls. I have to remember to save the file type as .xlsx everytime when i create a new excel file. "Sheeloo" wrote: Are you saying that even if you create a new workbook and save it for the first time, it gets saved as XLS? Pl. confirm. Also describe the steps you take to save... "Carina" wrote: No. For some reason, my excel 2007 default is .xls. I know i can do save as or convert to .xlsx but it is annoying that everytime when i open up a new session, i can only see 65,000 rows and in compatible mode. "Sheeloo" wrote: I thought that XLSX is the default format for Excel 2007. How are you saving? If you open an XLS file then it will be saved in the same format unless you choose SAVE AS "Carina" wrote: I tried to change the file save format under Excel Options to .xlsx but it only works on the current session. Once I close out and reopen, it switched back to .xls. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I set default Excel Saveas file format to xlsx not xlsx | Setting up and Configuration of Excel | |||
| I need to save "xlsx" file as excel | Excel Discussion (Misc queries) | |||
| Substituting a xls format with a xlsx format file | New Users to Excel | |||
| Excel automatically resets default save file format | Excel Discussion (Misc queries) | |||
| Excel continues a loop to ask to save default file, book1 | Excel Discussion (Misc queries) | |||
Linear Mode
