I'm using 2007 Excel and Access. I've got a pivot table linked directly to a MS Access database. The table is large around 400K records.
First refresh-The initial pivot refresh takes it's time refreshing the data, then relatively quickly will update the fields.
Second refresh-After the connection is established, the pivot refresh blazes through the "reading Data:" stage; however, stalls at the "updating fields:" stage.
It's really bizarre, you would expect the refresh to be significantly quicker the second time (because the connection has already been established), but it is usually slower the second go around, with a much larger wait time on the "updating fields:" stage.
Anyone have any idea what is going on? Is there a data connection property that will help with this?
First refresh-The initial pivot refresh takes it's time refreshing the data, then relatively quickly will update the fields.
Second refresh-After the connection is established, the pivot refresh blazes through the "reading Data:" stage; however, stalls at the "updating fields:" stage.
It's really bizarre, you would expect the refresh to be significantly quicker the second time (because the connection has already been established), but it is usually slower the second go around, with a much larger wait time on the "updating fields:" stage.
Anyone have any idea what is going on? Is there a data connection property that will help with this?
