Excel calculation services cache

Question

How can i disable Excel services calculation cache? I have some custom UDF in excel  which got executed from the server and after some amount of time the values will change in server. So the second time when we refresh the workbook , it loads the old cached values from the workbook .
How can disable the caching mechanism?

Answer 1

Hi,

 

The issue may be caused by that in Microsoft Excel Calculation Services; you set the Workbook Cache size to a smaller value than that of the Maximum Private bytes (memory cache size). When the server runs out of disk space in this case, ECS will never remove any of the unused workbooks from the Workbook cache. Therefore, it cannot load any new workbooks until you reboot the server (IISRESET). If I am right, please try to set the Workbook cache size to a greater value than that of memory cache.

 

For more information about Configure Excel Services settings, please refer to: http://technet.microsoft.com/en-us/library/cc263022.aspx

 

Hope it helps.

---

Xue-Mei Chang

Answer 2

Same Issue i had,

IISReset could have certainly resloved.

What i did was only Recycle the Application pool for the particular web app.

& Issue is resolved!!!!

I went for recycling & not iisreset since some backend jobs were running & i had to wait for them for iisreset.

In case anyone faces to go go for IISRESET i would strongly advise try with Recycling app pool first.

It has less impact on sp farm & mostly works for iis reset related stuff for a web app.

---

Rgds, Minesh