Pivottable linked to Access problems

  • Thread starter Thread starter Jeff Beamer
  • Start date Start date
J

Jeff Beamer

Hi,

I have a large Access database (300,000 rows) linked to an
Excel pivottable. As the database has grown, the
linking/refreshing performance has decreased and lately
it's been crashing. I've worked around it by creating
smaller queries off the main table and linking them to the
pivot tables. My question is if anyone knows if MS Office
2003 or XP works better, cause I'm using MS Office 2000.
If so, I'll want to upgrade!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

erratic response while working on a table in excel linked to a tab 2
Changing Database links? 3
Pivottable refresh problem 1
Update PivotTable 8
Checking/amending the external source link to an Access table 1
Pivot table turned flat! 5
automating external linked pivot table 2
Problem with PivotTable of FoxPro Database 2

Back
Top