Copying an Array formula

[Vance K]

I have multiple array lookups in one tab that refer to multiple tabs within
the workbook. All of the formulas have copied just fine except the last one.
It will only copy half way down the spreadsheet. When I try and copy it dow
or input another formula, the cell just stays blank. Has anyone seen this
before?

 

[Max]

.. Has anyone seen this before?
Yes. Once, a couple of years ago
Looks like we hit an Excel limit somewhere

 

[Simon Murphy]

Yep I've had that too
There is some info here
http://support.microsoft.com/kb/166342

I seem to remember it hit me at 38,000 or so. Can't remember, but like
you it just stopped pasting, no warning, just blanks.

Cheers
Simon
Excel development website: www.codematic.net

 

[Sandy]

This has just happened to me..have you figured out why?