Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training course - Array formulie

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

excel training course - Array formulie

Resolved · Low Priority · Version Standard

Reply Wed 15 Aug 2007, 09:52 Edited on Mon 20 Aug 2007, 15:44Delegate Gerald said...

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

For upcoming training course dates see: Pricing & availability

Reply Tue 25 Sep 2007, 10:11Trainer Anthony said...

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

Excel articles

· Excel Charts As Easy As Pie
· Create A Basic Timeline In Excel
· Tips From Excel's 'Rarely Used' File
· Securing Critical Company Information With Simple Visual Basic Training Courses
· Joseph And His Chart Of Many Colours

Excel tip:

How to apply the same formatting and data to multiple sheets at the same time in Excel 2010

When you want to format more than one sheet in a worksheet exactly the same way, Ctrl-click the tabs of the sheets you want to group together and they will all turn white. While they are grouped, anything you enter in one sheet gets entered into the others.

After you have done this, remember to click on the tabs to take them out of the group so that you do not accidentally insert data in multiple sheets when you just want to insert data in one.

View all Excel hints and tips