Open a big file

sezzo · Apr 26th, 2002, 06:30 AM

I want to open a file automatically but this file is bigger then Microsoft Excel allows.
How I can seperate it into two sheets automatically?
Thanks

Jackeb · Apr 26th, 2002, 06:48 AM

what type of file is it that you are trying to open?

Ed

Jack in the UK · Apr 26th, 2002, 12:09 PM

Any update on te file discription mate?

Anne Troy · Apr 26th, 2002, 12:48 PM

I'm interested in the part about:

"bigger then Microsoft Excel allows"

I believe the size of a workbook is limited only by the available memory on a given PC. Perhaps your available memory is hurting. Try cleaning up your PC:

http://www.thewordexpert.com/cleanyourpc.htm

If that doesn't help, try getting the file to a machine that has more RAM.

Hope this helps!

Parra · Apr 26th, 2002, 12:59 PM

Depending on what you are trying to do for example a Pivot Table for data analysis. You can imported to MS Access and then link to it from Excel.

Jack in the UK · Apr 26th, 2002, 01:01 PM

sorry just been thinking is this an excel file or some imported file .. poss odbc link?

_________________
If you can help a guy in trouble -
If you can sort that nagging problem -
Pease try, at home, at work or on a message board.

Others help you!
So PLEASE help if you can - If only the once.

Thank you -

Rdgs
======

[ This Message was edited by: Jack in the UK on 2002-05-01 12:08 ]

Anne Troy · Apr 27th, 2002, 12:00 PM

Jack: I have never removed your posts. I do not have that capability. Also, perhaps the asker does not have enough space on his hard drive to create the temporary file necessary to open his document. Cleaning up his hard drive may resolve the problem.

_________________
TheWordExpert

[ This Message was edited by: Dreamboat on 2002-04-27 11:03 ]

sen_edp · Apr 27th, 2002, 03:51 PM

hello there

I think the first poster means that the file
he wants to import is more than 65535 rows
and excel can't handdle them.
I suggest to break that file with an editor
in two or three and then import in excel

Jack in the UK · Apr 27th, 2002, 03:56 PM

Hi --

sounds like you could have excel file greater that 65536 rows deep can you split this data into two sheets>

_________________
If you can help a guy in trouble -
If you can sort that nagging problem -
Pease try, at home, at work or on a message board.

Others help you!
So PLEASE help if you can - If only the once.

Thank you -

Rdgs
======

[ This Message was edited by: Jack in the UK on 2002-05-01 12:07 ]

Apr 26th, 2002, 12:09 PM	#3
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	Any update on te file discription mate? __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Apr 26th, 2002, 12:48 PM	#4
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	I'm interested in the part about: "bigger then Microsoft Excel allows" I believe the size of a workbook is limited only by the available memory on a given PC. Perhaps your available memory is hurting. Try cleaning up your PC: http://www.thewordexpert.com/cleanyourpc.htm If that doesn't help, try getting the file to a machine that has more RAM. Hope this helps! __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 26th, 2002, 06:30 AM	#1
sezzo New Member Join Date: Apr 2002 Location: Germany Posts: 1	I want to open a file automatically but this file is bigger then Microsoft Excel allows. How I can seperate it into two sheets automatically? Thanks

Apr 26th, 2002, 06:48 AM	#2
Jackeb Board Regular Join Date: Mar 2002 Posts: 81	what type of file is it that you are trying to open? Ed

Apr 26th, 2002, 12:59 PM	#5
Parra Board Regular Join Date: Feb 2002 Location: Los Angeles, CA Posts: 752	Depending on what you are trying to do for example a Pivot Table for data analysis. You can imported to MS Access and then link to it from Excel.

Apr 26th, 2002, 01:01 PM	#6
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	sorry just been thinking is this an excel file or some imported file .. poss odbc link? _________________ If you can help a guy in trouble - If you can sort that nagging problem - Pease try, at home, at work or on a message board. Others help you! So PLEASE help if you can - If only the once. Thank you - Rdgs ====== [ This Message was edited by: Jack in the UK on 2002-05-01 12:08 ]

Apr 27th, 2002, 12:00 PM	#7
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	Jack: I have never removed your posts. I do not have that capability. Also, perhaps the asker does not have enough space on his hard drive to create the temporary file necessary to open his document. Cleaning up his hard drive may resolve the problem. _________________ TheWordExpert [ This Message was edited by: Dreamboat on 2002-04-27 11:03 ]

Apr 27th, 2002, 03:51 PM	#8
sen_edp Board Regular Join Date: Mar 2002 Location: Hellas Posts: 553	hello there I think the first poster means that the file he wants to import is more than 65535 rows and excel can't handdle them. I suggest to break that file with an editor in two or three and then import in excel

Apr 27th, 2002, 03:56 PM	#9
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	Hi -- sounds like you could have excel file greater that 65536 rows deep can you split this data into two sheets> _________________ If you can help a guy in trouble - If you can sort that nagging problem - Pease try, at home, at work or on a message board. Others help you! So PLEASE help if you can - If only the once. Thank you - Rdgs ====== [ This Message was edited by: Jack in the UK on 2002-05-01 12:07 ]