PC Review


Reply
Thread Tools Rate Thread

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

 
 
jjjbbb
Guest
Posts: n/a
 
      9th Jan 2010
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.
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I remove line breaks from several cells? JR Microsoft Excel Misc 6 15th May 2009 03:20 AM
Line breaks in my cells... =?Utf-8?B?QWtlbEE=?= Microsoft Excel Misc 3 3rd Oct 2007 07:18 PM
How do I remove line breaks in Excel cells? =?Utf-8?B?SG9sbHk=?= Microsoft Excel Misc 1 3rd Nov 2004 01:19 AM
how to paste data from word with line breaks (^l) to excel vixenyx Microsoft Excel Misc 1 14th Sep 2004 12:18 PM
Re: Export Report with out line breaks Rick B Microsoft Access Reports 1 30th Jun 2004 05:01 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:27 AM.