Keeping a workbook "pinned" in memory

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
 

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: performance, excel

 

2007-2015 VidasSoft Systems Inc.