Selection Too Large Message

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to copy a set of about 8 formulas from one row to the clipboard,
the try to paste the clipboard to about 12000 rows. The original formulas
and the destination range are both on the same worksheet. When I select the
destination range and click Paste, I get a message about Selection Too Large.

As near as I can tell, it is not version related because this occurs on both
Excel 2000 and 2002. I am running Windows XP Pro with 512Mb RAM with Excel
2002. This problem is becoming a major roadblock in the completion of my
project and I need to get a handle on what is happening and if there is a
workaround or solution. Can someone tell me why this is occurring?

Thanks.

PS: In case the idea comes up, using Access is not an alternative.

Thanks.
 
Depending on how complicated the formulas are, have you tried copying one
formula at a time?
 
Back
Top