Hello,

I have a workbook that contains pivot tables that has become too big and I
would like to move the pivot tables to another workbook. When I move the
sheets containing the pivot tables to a new workbook, at first everything
works fine, e.g., I can make changes to the data on the original workbook
then switch over to the new workbook with pivot tables and update data, etc.
However, when I save, close, then reopen, I get an error that the new pivot
table is not valid. Is it possible to have pivot tables stored in a separate
workbook? Any help would be very much appreciated.