Export xlsx format

D

dplunkett

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/com...4-61f298a34452&dg=microsoft.public.excel.misc
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export BPMN Visio Chart to Excel 0
Working outlook via vba code with xlsx - error 0
Excel Column Width in XLSX 0
Outlook 2021 export question 0
Excel 2003 save as .XLSX 12
Excel does not accept text format! 0
Exporting to Excel 2007 format from asp.net application 0
Table of content - format does not get saved 2

Top