You are reading a single comment by @Sam_w and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
Sam_w
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?