Delay pulling data from one sheet to two other sheets in workbook

%3CLINGO-SUB%20id%3D%22lingo-sub-2667201%22%20slang%3D%22en-US%22%3EDelay%20pulling%20data%20from%20one%20sheet%20to%20two%20other%20sheets%20in%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2667201%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20an%20excel%20file%20where%20when%20I%20try%20to%20pull%20data%20from%20a%20cell%20from%20one%20sheet%20to%20another%2C%20I%20get%20a%20major%20stall.%26nbsp%3B%20It%20only%20happens%20from%20one%20particular%20sheet%20to%20two%20particular%20sheets%20in%20that%20order%E2%80%A6.no%20other%20sheets%20have%20this%20delay.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20idea%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20same%20exact%20workbook%20doesn%E2%80%99t%20not%20have%20this%20trouble%20on%20other%20computers%2C%20either.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2667201%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2668349%22%20slang%3D%22en-US%22%3ERe%3A%20Delay%20pulling%20data%20from%20one%20sheet%20to%20two%20other%20sheets%20in%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2668349%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1068814%22%20target%3D%22_blank%22%3E%40mikeshick%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAre%20other%20computers%20with%20exactly%20same%20version%20of%20Excel%20%3F%20At%20least%20do%20all%20support%20dynamic%20arrays%20or%20do%20all%20not%20support.%3C%2FP%3E%0A%3CP%3EAre%20other%20computers%20in%20the%20same%20environment%2C%20in%20particular%20all%20have%20the%20same%20access%20to%20linked%20file%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20332px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F304605iC8E294AF6F042330%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EIf%20to%20check%20workbook%20it's%20desirably%20to%20explain%20the%20situation%20in%20more%20details%20-%20which%20concrete%20cell(s)%20into%20which%20concrete%20target%20cell(s)%20you%20try%20to%20pull%20and%20how.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2670405%22%20slang%3D%22en-US%22%3ERe%3A%20Delay%20pulling%20data%20from%20one%20sheet%20to%20two%20other%20sheets%20in%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2670405%22%20slang%3D%22en-US%22%3Esome%20computers%20have%20same%20version%2C%20others%20not.%20We%20use%20dropbox%2C%20so%20all%20have%20access%20to%20same%20file%20that%20is%20syncd.%3CBR%20%2F%3E%3CBR%20%2F%3EAny%20cells%20from%20Load%20Deriviation%20to%20Lat-UL%20or%20Lat-LL%20via%20%3D%20and%20the%20cell%20from%20load%20derivation.%3C%2FLINGO-BODY%3E
New Contributor

I have an excel file where when I try to pull data from a cell from one sheet to another, I get a major stall.  It only happens from one particular sheet to two particular sheets in that order….no other sheets have this delay.

 

Any idea?

 

The same exact workbook doesn’t not have this trouble on other computers, either.

2 Replies

@mikeshick 

Are other computers with exactly same version of Excel ? At least do all support dynamic arrays or do all not support.

Are other computers in the same environment, in particular all have the same access to linked file

image.png

If to check workbook it's desirably to explain the situation in more details - which concrete cell(s) into which concrete target cell(s) you try to pull and how.

some computers have same version, others not. We use dropbox, so all have access to same file that is syncd.

Any cells from Load Deriviation to Lat-UL or Lat-LL via = and the cell from load derivation.