I have a load of existing services we use for Local View maps.. we'd like to reuse them in ESRI for Office but when I add a service I can only see one featureclass from the service. Our services tend to have 20-30 featureclasses in them, otherwise we'd have literally hundreds of services which would be unworkable.
Is there something I'm missing in the set up? Should I be able to see multiple featureclasses in the service when used in Excel?