Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 214015 - Last Review: December 2, 2005 - Revision: 3.3
XL2000: "File Not Loaded Completely" Error Message When Running Text Import Wizard
This article was previously published under Q214015
When you use the Text Import Wizard to import a text file, and specify a value of 32,768 or higher in the
Start import at row box in step 1, you may receive one of the following error messages:
File not loaded completely.
-or-
NOTE: Microsoft Office 2000 has built-in functionality that allows you to get more information about difficult-to-troubleshoot alerts or error messages. If you want to enable this functionality for this and other error messages in Microsoft Office 2000, please download the Microsoft Office 2000 Customizable Alerts file from the Microsoft Office Update Web site at the following address:
NOTE: If you reached this article by clicking the
Web Info button in an error message, you already have Customizable Alerts enabled.
The maximum number of rows you can specify using the Text Import Wizard is 32,767.
The maximum number of rows in an Excel 2000 worksheet is 65,536. If
you open a text file with 65,536 rows or fewer, all rows of the text file will be imported into one worksheet. However, if you attempt to import more
rows than are available in the worksheet, only 65,536 rows of the text file will be loaded, and you will receive one of the error messages described in the "Symptoms" section of this article.
If your worksheet contains more than 65,536 but fewer than 98,304 rows,
you can use the Text Import Wizard to import the text file into multiple
worksheets by following these steps:
- On the File menu, click Open. Select the text file you
want to open and click OK.
- In the Text Import Wizard, type or select 1 in the
Start import at row box and then click
Finish.
- The first 65,536 rows of the text file are imported into a worksheet,
and you receive the error message, "File not loaded completely." Click
OK. Save this workbook.
- Repeat step 1. In the Text Import Wizard, select 32,767 in the Start import at row box, and click Finish.
- Note that 65,536 rows of the text file starting at row 32,766 are
imported into a worksheet. Save this workbook.
- You can delete the first 32,770 rows in this workbook because these rows
were also imported into the workbook you saved in step 5. Save this
workbook.
If your worksheet contains more than 98,303 rows, perform steps 1 through 6 and then follow these steps:
- Open the worksheet containing more than 98,303 rows.
- Delete the first 98,303 rows.
- Save the file, and then import the remaining rows by following
steps 1 through 6 again.
Repeat this process until you have imported all the rows in your worksheet. Note that you should make a back up copy of your file before you delete any text from it.
APPLIES TO
- Microsoft Excel 2000 Standard Edition
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate
Be the first to leave feedback, to help others about this knowledge base
article.
(Optional) Name
(Optional)
Public URL Or Email
Comments
No
HTML -- Text Only Please