cant export to excel unless I reduce data in cells and line breaks

J

jjjbbb

I am using software that searches a sql database and generates an index
report. When I try to export a report to excel (2007) from within the
software (print to file .xls), it acts like it is working, but no file is
saved in the specified location. The report has several hundred characters
in a cell with line breaks (30-40). If I reduce the report to fewer
characters per cell with one or two line breaks, I can successfully create
the file, but not with the larger amount of data. I am nowhere near the cell
limits of 30,000+ characters. I have tried on several other computers
running different versions of excel with the same results. I have one
machine running Excel 2007 that will create the file with the large results,
but i cant make the others do it. Anybody have ideas? Thanks.
 

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

Top