Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 12
Default Limit on array formula

Is there a limit on how many cells in a worksheet can contain an array
formula. My sheet seems to cap out and not allow me to copy the formula down
after a certain number of rows.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,688
Default Limit on array formula

See if this helps:

http://support.microsoft.com/kb/166342/EN-US/

Biff

"LizM" wrote in message
...
Is there a limit on how many cells in a worksheet can contain an array
formula. My sheet seems to cap out and not allow me to copy the formula
down
after a certain number of rows.



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 12
Default Limit on array formula

Thank you so much!

"Biff" wrote:

See if this helps:

http://support.microsoft.com/kb/166342/EN-US/

Biff

"LizM" wrote in message
...
Is there a limit on how many cells in a worksheet can contain an array
formula. My sheet seems to cap out and not allow me to copy the formula
down
after a certain number of rows.




  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,688
Default Limit on array formula

You're welcome.

Biff

"LizM" wrote in message
...
Thank you so much!

"Biff" wrote:

See if this helps:

http://support.microsoft.com/kb/166342/EN-US/

Biff

"LizM" wrote in message
...
Is there a limit on how many cells in a worksheet can contain an array
formula. My sheet seems to cap out and not allow me to copy the
formula
down
after a certain number of rows.






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Array Formula Not Working with Range with Formulas [email protected] Excel Discussion (Misc queries) 4 February 1st 06 02:01 PM
Array formula returning wrong results TUNGANA KURMA RAJU Excel Discussion (Misc queries) 1 November 19th 05 10:29 AM
referencing the value of a cell containing an array formula KR Excel Worksheet Functions 4 July 5th 05 06:15 PM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 07:48 PM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 03:28 AM


All times are GMT +1. The time now is 10:57 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"