Export xlsx format
I am using Accounting Software that allows export of reports to Excel Format.
I am using Excel 2007. Issue 1 Each time export box is used this automatically selects *.xls format. I have checked ODBC Settings in Control Panel and Excel Driver identifies V12.0 and refers to xls / xlsx etc but only ever exports to .xls format. I have spoken to the software manufacturer and they have advised that the xls format applied is a microsoft issue not their own. Is there any way I can change the export format to default to xlsx format? Issue 2 Upon viewing data in Excel 2007 it then identifies in wrong format and needs to be saved in a new format. I discovered last night that in Excel options I could change Save format to Excel 97-2003 Worksheet so this may reolve this Issue. Please advsie asap Many Thanks ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
Export xlsx format
Hi
Item 1 is an issue with the exprting process and how the accounting software works. Item 2 But generally excel should process the file, but there can be problems with dates as in m/d and d/m formats. -- Hope this helps Martin Fishlock, www.nyfconsultants.com, Wolverhampton, UK Please do not forget to rate this reply. "dplunkett" wrote: I am using Accounting Software that allows export of reports to Excel Format. I am using Excel 2007. Issue 1 Each time export box is used this automatically selects *.xls format. I have checked ODBC Settings in Control Panel and Excel Driver identifies V12.0 and refers to xls / xlsx etc but only ever exports to .xls format. I have spoken to the software manufacturer and they have advised that the xls format applied is a microsoft issue not their own. Is there any way I can change the export format to default to xlsx format? Issue 2 Upon viewing data in Excel 2007 it then identifies in wrong format and needs to be saved in a new format. I discovered last night that in Excel options I could change Save format to Excel 97-2003 Worksheet so this may reolve this Issue. Please advsie asap Many Thanks ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
All times are GMT +1. The time now is 11:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com