I have a file of 90k, how do I open it without data loss
I icestationzbra Sep 28, 2004 #2 do you mean 90 KiloBytes in size? i have excel files that are about 2 MB, and i have not experienced any data loss of them when i open it what is the exact problem that you are having, or fear having
do you mean 90 KiloBytes in size? i have excel files that are about 2 MB, and i have not experienced any data loss of them when i open it what is the exact problem that you are having, or fear having
D Dave Peterson Sep 28, 2004 #3 If you're importing a text file... Maybe you could use your favorite text editor and split your data into pieces--and then import each piece to a new worksheet. Microsoft has a macro solution that does something similar: http://support.microsoft.com/default.aspx?scid=kb;EN-US;q120596 XL: Importing Text Files Larger Than 16384 Rows (written for xl95, but has a note to change stuff for xl97+) If it's not ok to have separate worksheets, then maybe excel ain't the solution to this problem.
If you're importing a text file... Maybe you could use your favorite text editor and split your data into pieces--and then import each piece to a new worksheet. Microsoft has a macro solution that does something similar: http://support.microsoft.com/default.aspx?scid=kb;EN-US;q120596 XL: Importing Text Files Larger Than 16384 Rows (written for xl95, but has a note to change stuff for xl97+) If it's not ok to have separate worksheets, then maybe excel ain't the solution to this problem.
