Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Copying an Array formula
1 view
Skip to first unread message
Vance K
Nov 6, 2009, 1:06:08 PM11/6/09
to
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?
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
Nov 11, 2009, 4:59:02 PM11/11/09
to
> .. Has anyone seen this before?
Yes. Once, a couple of years ago
Looks like we hit an Excel limit somewhere
Yes. Once, a couple of years ago
Looks like we hit an Excel limit somewhere
Simon Murphy
Nov 12, 2009, 8:27:40 AM11/12/09
to
Yep I've had that too
There is some info here
http://support.microsoft.com/kb/166342
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
Nov 12, 2009, 6:08:02 PM11/12/09
to
This has just happened to me..have you figured out why?
0 new messages