If I have multiple pivot tables linked to a large data set, will my pivot tables run faster if they are linked to a data set somewhere outside of the file?
If I have multiple pivot tables linked to a large data set, will my pivot tables run faster if they are linked to a data set somewhere outside of the file?
I have always found external links to be slower than links to data within a file. I don't have data to support this though.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks