I am populating cells in spreadsheet A using GETPIVOTDATA. The pivot table is saved in spreadsheet B, which is a huge file and takes a while to open. Problem is that if you don't have spreadsheet B open, A shows #REF! in the cell with the GETPIVOTDATA formula. Is there another way around this? These documents are shared by many people and I would prefer that they don't have to open B to get A to calculate correctly. Hope this makes sense. Thanks.