Pivot Table -- Tuning ??

D

danegrey

Hi,

Working with a user, whose excel spreadsheet is 3.5 MB, located on
network drive. Table has 4400 rows.

Doing analyzes by using pivot tables. Problem is the file is slow t
save,
very slow up to 10 minutes.

I'm just want to determine, if the file is too large for Excel (whic
is 97) and pivot tables. Or if there is something else I can do, t
help her.

thanks ahead of time
 
M

Myrna Larson

I suspect this is a network issue.

What happens to the speed if you copy the file to her local drive and work
with it there, then copy back to the network server when finished with it?
 
A

Alex Delamain

Definitely sounds like the network.
I have spreadsheets of over 10MB with multiple pivot tables and the
still only take 10-15 seconds to save (it just feels like hours
 

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

Pivot Table and Merged Cells Help 1
Multiple Tables and Multiple Pivot Tables Help 0
Pivot Table Source file 2
Slicers and Calculated Items in Pivot Table 2
Combine Pivot tables - confused about 'how-to' 6
Pivot Table sorts date as Alpha, not as Date 6
Pivot Tables (Sumif) 2
Pivot Table from Access DB 3

Top