Selection Too Large Message

M

Martin

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.
 
P

Penny

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The picture is too large and will be truncated 1
Selection Too Large Message 0
Selection Too Large 0
Selection is too large 1
selection too large 3
Large Amount of Info on Clipboard 3
Selection is too large - when pasting formats programmatically 0
Selecting Range of Copied Text 2

Top