Linked workbook

[brucemc777]

I am very, very new to linking, to the point that though I have a project in which I am extensively using linking due Monday, I would say I am still experimenting with it for it seems to be the direct answer, at least according to Microsoft.

I will have 10 to 20 satellite workbooks that one workbook at a receptionist station will draw information from. All so far appear fine in the virtual world where there are no bullets introduced.

Right now, the test is limited to one satellite workbook. The number of links from that one satellite workbook has (which will be identical with all others, in case the number throws up a flag with anyone experienced with this) is roughly 22,000 cells (20 individuals x 365 days x three rows per person), so the total should be a maximum of 440,000 when complete. I expect cell changes in satellite workbooks to occur at an approximate rate of 200/day.

When I have the satellite workbook open and then open the reception workbook all is fine and it pops right up after asking for permission to update, results shown, I am happy.

However, if I close the satellite workbook and leave the receptionist workbook open (which many times will be the case) the receptionist workbook goes into fibrillation, keeping attempting to recalculate continuously. I am now imagining that times 20 and it isn't a pretty picture for my continued employment...

Certainly something this basic must be accommodated and I simply do not know how to properly implement - can anyone advise?


Edit: Suspecting something was creeping in, I started with a much smaller model. No problem like above. I am trying to add piece-by-piece. If you have an idea as to what might cause the behavior above, I sure would like to know. If I trip on which step, I will post. I don't know if it was some of the "On Change" code behind the page in the receptionist side, or the satellite side, or what. Most of the satellite side was a large area copy from the receptionist sheet and then paste links to the satellite page. After several hours of researching linking yesterday and today, I think if this was a normal problem I would have found more. Must of been my "creativity"...

[FDibbins]

Links to even 20,000+ cells could start to slow your file down, 440K will almost certainly drag it down I am getting the feeling you need to rethink this, that maybe you need to (if this is what may be happening?) do any calcs in the feeder WB's, and use the "master" just for the summary?

[brucemc777]

Agreed. I am going off in another direction with copying cells over, but I had at first avoided this because it has been a really, really long time and I don't know how file locking for writing is handled in a multi-user environment and anything else that can go wrong (will go wrong) as I am somehow related to Murphy of Murphy's Law...