I have a workbook with a few very large data sheets. When I use office 2007, my macros run w/o problems. When I run in 2010 I keep getting,

"Excel cannot complete this task with available resources. Choose less data or clos other applications"

There is only one excel doc open, all my pages are zoomed at 100%. Even when the macro isn't executing, and I attempt to sort (which is where I get hung up) I get the same message.

Any suggestions?

Thanks,