Hi Devon,
Thank you that worked but my excel is locking up trying to query the View.
I tried it with another view that someone else created and I had same issue.
Small Views seem to work fine.
I think I might have to just make an interim file.
thanks for you help though.