Thanks Tony,

When I try that I get an error the reads "Excel cannot complet this task with available resources. Choose less data or close other applications.

I'm not on a server yet, still just on one PC until I see how this fits my co's situation. I have a pretty big and robust PC and using Excel 2010. I really need to have all the data captured. My spreadsheet goes to AJ750 with only about a third of the cells containing formulae so I don't consider that extraordinarily large.How do I get around this?

Thanks again for your advice.
RR