Pivot tables and shared workbooks

J

Jim F.

I am aware that you cannot refresh a pivot table while the
workbook is shared, but was curious as to why this is
true. What is Microsoft's reasoning behind not allowing
refreshing of pivot tables in shared workbooks? I really
need to keep the history file but can only refresh while
it is unshared - which loses the history.
 
Top