Keeping a workbook "pinned" in memory
User Rating: / 0
PoorBest 
Written by Dave Wickert   
Thursday, 04 March 2010 00:41

One of the special considerations that arise when demonstrating PowerPivot is that you would like to ensure the workbooks that you are showing are kept in memory all of the time. PowerPivot does not have a built-in ‘pin’ feature to do this, but there is nice trick that you can use. Here is what I do:

Read more...

 

  Tags: excel, performance