petersoncap
New Member
- Joined
- Jun 24, 2009
- Messages
- 2
I'm using an Access table with around 220K lines to create a pivot table that should end up with around 15K rows and 16 columns total.
I have created pivot tables like this before, in fact I create one every month and haven't had any problems that I can't solve, but this one has me stumped.
It will retrieve the data, update the fields, and get about halfway through creating the pivot table. Then it just stops. All dialogue boxes go away, I don't get any warnings or errors, and no pivot table appears. I'm left with a worksheet that is as blank as a new one.
I'm at a bit of a loss. I recreated the source data file and put in only half the data and I get the same result. I can create small pivot tables from a 3x3 set of random data, but I'm lost without so much as an error message.
Could this be a memory problem? I'm trying to convince IT to get me set up with 2007 instead of Excel 2003.
I have created pivot tables like this before, in fact I create one every month and haven't had any problems that I can't solve, but this one has me stumped.
It will retrieve the data, update the fields, and get about halfway through creating the pivot table. Then it just stops. All dialogue boxes go away, I don't get any warnings or errors, and no pivot table appears. I'm left with a worksheet that is as blank as a new one.
I'm at a bit of a loss. I recreated the source data file and put in only half the data and I get the same result. I can create small pivot tables from a 3x3 set of random data, but I'm lost without so much as an error message.
Could this be a memory problem? I'm trying to convince IT to get me set up with 2007 instead of Excel 2003.