98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » excel training course - Array formulie
excel training course - Array formulie
Resolved · Low Priority · Version Standard
Gerald has attended:
Excel Advanced course
Array formulie
Hi
Could somepne please enlighten me as to the maximum number of variables that an array formula can support, and also can it reference woorkbooks on different servers if all the books are opened and refreshed?
Thanks in advance.
Kind regards,
Gerald
RE: Array formulie
Hi Gerald. According to this:
http://support.microsoft.com/kb/177991
The maximum number of elements is 6,550, before you get an Out of Memory error message. To get around that I'd just set up successive arrays. Secondly, you shouldn't have any problems sending information to your arrays from workbooks on different servers, but you might have to assign the filepath of those workbooks to a variable, than use the raw path.
Hope this helps,
Anthony
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Quickly Adding New WorksheetsWant to place a new Excel worksheet before current worksheet. Use keystroke SHIFT+F11 |