I've run into a road block on this one.

Should be easy enough.

I have 3 sprocs which build standard data sets based on a reference number input on the first/summary worksheet the user sees. Unfortunately, Excel doesn't want to allow a simple data connection and reference to the ref # cell address.

Ideas? Frustrating.