Errorr

%3CLINGO-SUB%20id%3D%22lingo-sub-2755346%22%20slang%3D%22en-US%22%3EErrorr%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2755346%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3Egetting%20this%20message%3A%20%22This%20table%20inserted%20rows%20to%20your%20worksheet.%20this%20may%20cause%20data%20in%20cell%20below%20the%20table%20to%20shift%20down.%22%3C%2FP%3E%3CP%3EI%20have%20a%20excel%20table%20connected%20to%20a%20sharepoint%20list%2C%20and%20the%20data%20from%20the%20table%20goes%20to%20some%20formulas%20in%20another%20sheet%2C%20when%20new%20data%20comes%20into%20the%20table%20this%20error%20appears%20and%20it%20shifts%20the%20cells%20down%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2755346%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi all,

getting this message: "This table inserted rows to your worksheet. this may cause data in cell below the table to shift down."

I have a excel table connected to a sharepoint list, and the data from the table goes to some formulas in another sheet, when new data comes into the table this error appears and it shifts the cells down, 

 

Thanks

 

1 Reply