In my experience with Power Pivot this error usually occurs when you pc memory isn't sufficient to refresh all the tables at once. I haven't found a way around it (although we have upgraded my pc to handle my data requirements). You either have to refresh each table individually after you close every open application (including Excel), reload excel and the power pivot file and then refresh. You may want to review the amount of data you are loading into the power pivot.