i was trying to combine tables to make a pivot table and when it was counting the records to create the table excel comes up with an error "Not enough memory" any thoughts on how to change that? i have upgraded memory and shut off everything on my computer except access and excel.