Results 1 to 2 of 2
Thread: Pivot-table refresh (WXP, O2000)
2003-12-04, 07:47 #1
- Join Date
- Nov 2003
- Thanked 0 Times in 0 Posts
Pivot-table refresh (WXP, O2000)
I have an Excel workbook with several pivot tables, which get their data from an Access file via Query.
This was all going well until recently.
The time for a refresh has increased all of a sudden from 10 seconds to 10 minutes. This goes together with heavy activities on the hard disk. The task manager tells me that the CPU is hardly used.
I ran repair on the Access database, no change.
Using a different database - same result.
The Access drivers seems to be there.
A new installation of Office did not change anything.
A new query to the same database was also resulting in extremely long time for the creation.
The same program is working on other machines with (more or less) identical files without problems.
Any idea what I can do?
Thanks in advance
2003-12-04, 14:51 #2
- Join Date
- Dec 2000
- Sacramento, California, USA
- Thanked 1 Time in 1 Post
Re: Pivot-table refresh (WXP, O2000)
It sounds like your hard drive could use some maintenance. Do you see the slowdown in Access or Excel?Charlotte