Excel-List Connection: adding new item to list messes up excel column formulas

%3CLINGO-SUB%20id%3D%22lingo-sub-734603%22%20slang%3D%22en-US%22%3EExcel-List%20Connection%3A%20adding%20new%20item%20to%20list%20messes%20up%20excel%20column%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-734603%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20Everybody%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20SharePoint%20list-Excel%20connection.%26nbsp%3B%20I%20have%20a%20PowerApp%20which%20allows%20you%20to%20add%20a%20new%20item%20to%20the%20list%2C%20which%20then%20imports%20the%20item%20into%20the%20excel%20file.%3C%2FP%3E%3CP%3EHowever%2C%20every%20time%20a%20new%20item%20is%20added%2C%20it%20affects%20columns%20on%20different%20sheets%20that%20use%20this%20list's%20information%20to%20do%20calculations.%26nbsp%3B%20Essentially%2C%20the%20formulas%20use%20the%20corresponding%20cells%20on%20the%20sheet%20with%20the%20SP%20list.%26nbsp%3B%20So%20row%202%20uses%20row%202%20on%20the%20other%20sheet's%20info.%3C%2FP%3E%3CP%3EBut%20when%20I%20add%20a%20new%20item%2C%20the%20ordering%20of%20the%20formulas%20gets%20messed%20up.%26nbsp%3B%20For%20example%2C%20cell%2014%20on%20a%20sheet%20with%20formulas%20will%20suddenly%20be%20referencing%20cell%2015%20on%20the%20other%20sheet.%26nbsp%3B%20Numbers%20get%20skipped%20or%20duplicated%20when%20items%20are%20added.%26nbsp%3B%20It%20seems%20to%20always%20mess%20up%20the%20row%20number%20one%20before%20the%20row%20number%20of%20the%20latest%20item%20added%20to%20the%20list.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20ideas%20to%20why%20this%20is%20happening%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-734603%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

Hey Everybody,

 

I have a SharePoint list-Excel connection.  I have a PowerApp which allows you to add a new item to the list, which then imports the item into the excel file.

However, every time a new item is added, it affects columns on different sheets that use this list's information to do calculations.  Essentially, the formulas use the corresponding cells on the sheet with the SP list.  So row 2 uses row 2 on the other sheet's info.

But when I add a new item, the ordering of the formulas gets messed up.  For example, cell 14 on a sheet with formulas will suddenly be referencing cell 15 on the other sheet.  Numbers get skipped or duplicated when items are added.  It seems to always mess up the row number one before the row number of the latest item added to the list.

 

Any ideas to why this is happening?

0 Replies