Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

report is not loaded properly

Created: 14 May 2013 • Updated: 18 May 2013 | 9 comments
This issue has been solved. See solution.

I have download the all installed software report. When i open the xxxxxx.csv file it showing error with File not loaded completely. I have extract the file number of time and every time file open with error.

My confusion is that this is a normal error message or some of rows are missing?

any permanent solution to fix it?

Comments 9 CommentsJump to latest comment

technical_specialist's picture

Hello

What is the current running version?

Kindly share the snapshot of error.

technical_specialist's picture

Hello

Download the report in different format like .html/.xml and check it working fine or not?

W007's picture

hello,

Can you provide office version ?

Your data limit are exceed for Rows

check this Microsoft KB

"File not loaded completely" error importing text files larger than 65536 rows in Mac XL

http://support.microsoft.com/kb/190032

Don't forget to mark your thread as 'SOLVED' with the answer that best helped you.

consoleadmin's picture

Excel has row limit 65536/1,048,576. If you have installed the excel 2003 then it limit is 65536. So you need to upgrade the excel later that 2003 version for getting the more row limit. 2007/2010 row limit is 1,048,576.

If in case your data is bigger than this count then easiest way is then you can split the file in 2 parts.

For splitting you can open the file in notepad and divide the data in 2 different notepad file and then save in .csv format. Try it.

http://forums.asp.net/t/1189246.aspx

Worksheet and workbook specifications and limits

http://office.microsoft.com/en-in/excel-help/excel-specifications-and-limits-HP010342495.aspx

Thanks.

SOLUTION
cec.kadu's picture

Rrajar,

Make a test, put a filter on report and export to csv.
Try to open, if the error not exist the problem is on limit of lines  of excel.

Custodio

Carlos Eduardo CUSTODIO

Altiris Consultant

Rrajar's picture

there are multiple software data which i was required so don't know how to create the filter for multiple.

KNP's picture

Hi,

Create a snapshot for filtered output report which has limited rows and then export report, it will confirm that whether problem for limit of lines in csv. file or some other side.

Rrajar's picture

I have divide the file in multiple with open it text format, but i am interested to know about snapshot, How to select snapshot?

How it work?