Copying an Array formula

Vance K · External Since: Nov 06, 2009 Posts: 1

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 · External Since: Mar 17, 2004 Posts: 1751

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

Simon Murphy · External Since: Jul 18, 2009 Posts: 8

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

Vance K wrote:
> 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?

Sandy · External Since: Mar 21, 2006 Posts: 485

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

"Vance K" wrote:

> 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?