limits on autofill

hawley · Apr 25th, 2002, 08:31 AM

Does anyone know if there is a limit on how many rows and columns can be used by autofill? I am trying to autofill 210 columns with data from 8776 rows.

Thanks-

jrnyman · Apr 25th, 2002, 08:36 AM

Shouldn't be a problem

hawley · Apr 25th, 2002, 09:27 AM

It is a problem though. I keep getting a memory error. I found one limitiation about the cell length and autofill but nothing about rows or columns. I know it is not my cell length because they are formulas and they have the same size restriction, 255 characters.

wilkisa · Apr 25th, 2002, 09:47 AM

I am unaware of any limits on autofill. However, the error that you are getting is coming from your PC, not Excel. You are asking the PC to calculate a large number of cells at one time if you are autofilling with a formula. Instead of doing all 210 columns at one time, try half of that and then when that is done, autofill the other half.

Also, have you cleaned out the TEMP folder in your Windows directory? And, have you emptied your Recycle Bin? Both of those objects take up memory resources that impact the function of your PC.

Hope this helps,
Shirlene

Jack in the UK · Apr 25th, 2002, 04:07 PM

dont fell should be issues

what spec PC are you running

1 Chip
2 Memory
3 On Network
4 Anti virus
(local install on network)

Apr 25th, 2002, 04:07 PM	#5
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	dont fell should be issues what spec PC are you running 1 Chip 2 Memory 3 On Network 4 Anti virus (local install on network) __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

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

Apr 25th, 2002, 08:31 AM	#1
hawley Board Regular Join Date: Apr 2002 Posts: 169	Does anyone know if there is a limit on how many rows and columns can be used by autofill? I am trying to autofill 210 columns with data from 8776 rows. Thanks-

Apr 25th, 2002, 08:36 AM	#2
jrnyman Board Regular Join Date: Mar 2002 Location: Boston, MA Posts: 105	Shouldn't be a problem

Apr 25th, 2002, 09:27 AM	#3
hawley Board Regular Join Date: Apr 2002 Posts: 169	It is a problem though. I keep getting a memory error. I found one limitiation about the cell length and autofill but nothing about rows or columns. I know it is not my cell length because they are formulas and they have the same size restriction, 255 characters.

Apr 25th, 2002, 09:47 AM	#4
wilkisa Board Regular Join Date: Apr 2002 Location: Decatur IL, USA Posts: 494	I am unaware of any limits on autofill. However, the error that you are getting is coming from your PC, not Excel. You are asking the PC to calculate a large number of cells at one time if you are autofilling with a formula. Instead of doing all 210 columns at one time, try half of that and then when that is done, autofill the other half. Also, have you cleaned out the TEMP folder in your Windows directory? And, have you emptied your Recycle Bin? Both of those objects take up memory resources that impact the function of your PC. Hope this helps, Shirlene