Excel 2007 Pivot table refresh crashes

V

vr4

I have a pivot table linked to another 2007 excel file for the data. When I
select refresh with the data file open there is no problem but when I have
the data file closed excel crashes. This always worked in Excel 2003.
 
V

vr4

I solved the problem. I have been using the top radio button (select a table
or range) as in 2003 which is default but now we need to use the 2nd button
(us an external data source). It works very fast now.
 
Joined
Jul 6, 2011
Messages
1
Reaction score
0
I abruptly began having this problem a couple months ago. The "external data source" button is not an option on my computer (greyed out), so how did you get it to work?
 

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

Top