Excel compatibility mode

[buckbuchanan]

Hi all

When I export data to excel, the file it generates seems to be in compatibility mode. The problem I have with this is that it limits the file to 65000 rows. Is there a way to force it to generate a normal xlsx file??

[alexa]

Does this happen only when exporting to the XLSX format or with any other one too?

Also, please check that Paginal mode is turned off. You can turn off Paginal mode either from the toolbar of Data Editor or in the 'Options' dialog:

1. Select 'Tools -> Options' from the main menu. The 'Options' window opens.
2. Navigate to the 'Data Editor -> General' branch.
3. Unselect the 'Use paginal mode by default' option.

Additionally, please let us know what version of dbForge you are using.

[buckbuchanan]

Hi Alexa
The only options I have when exporting are "MS Excel" and "MS Excel 2007" - I don't see an option to choose "XSLX". This problem happens when I choose MS Excel. It doesn't seem to be related to paginal mode - I have that turned off. What happens is once I go over 65000 rows the data gets split over 2 worksheets.
Thanks

[alexa]

Please select the 'MS Excel 2007' format. This way the exported file will be generated with the *.xlsx extension and you shouldn't experience the issue with the limit.

[buckbuchanan]

Yes - that works - thank you.
A bit misleading though as I expected MS Excel to be the latest version...