If you’re making use of the Microsoft Office XP Web Services Toolkit 2.0 to fetch web service data in Excel (this version of the toolkit is compatible with Excel 2007), you may stumble across an error something along the lines of “SoapMapper:Array dimensions do not match definition.”.
If the return type of the call is an array (which is declared as a Variant), or a property in your return type is an array (also declared as a Variant), this error is raised because the data returning from the call for the array has no elements.
If you stumbled upon this article looking for a way to call web services from Excel, I suggest this article on CodeProject as a starting point or this one from WindowsDevCenter. They both will give you the general idea.