You are reading a single comment by @rhb and its replies.
Click here to read the full conversation.
-
You can turn off the Getpivotdata aspect of the lookups, not sure if that might help.
-
How are you linking? Normal references or GETPIVOTDATA? I find the latter always causes issues.
You can probably replicate those summary pivot tables using SUMIFS or a FILTER formula as an alternative.
EDIT: I see it's getpivotdata. I would turn that off and see what happens. Although I'd be tempted to use formulas instead (unless there is loads of data) to avoid having to refresh.
Sam_w
aggi
@rhb
Q:
Workbook A pulls data from Workbook B, which can't be tinkered with too much as it feeds the bosses workbook C.
To get the data in a form that is useful to workbook A I had to create some summary Pivot tables in workbook B.
When these refresh, all the links in workbook A break and the cells give #ref error.
This takes ages to fix each time and my only workaround will be to manually copy the pivots data and paste as values into a new sheet in Workbook A from time to time, using that sheet as the lookup.
Am I overlooking something simple as a fix or could I be approaching this differently?