Error - maximum Allowed by Excel (32767) characters)

[knightingal]

I have PL/SQL Developer 12.0.5 (64bit). Whenever I try to Copy to Excel (xlsx) a large query, I get the error: is longer than the maximum allowed by Excel (32767 characters). This is the number of characters excel may contain in a single cell. When I run a smaller query, this works fine and the results fill in multiple columns/rows/cells as it is supposed to. Has anyone encountered this issue and if so, how do you fix it?

 

[Marco Kalter]

Does it help if you disable the "Export to Excel with SQL statement" option (Preferences > Files > Format)?

 

[knightingal]

Marco Kalter, thank you so much. It is exactly that. We were so focused on the first tab with all the results, we didn't even think of the second tab with the SQL query. I turned off and tried it again and it exported everything. Thank you for this.