Forum Discussion
MS Excel formula "skips" row based on input from MS Forms
Hi, I have an Excel Online document which receives survey data directly from a Microsoft Form. In the Excel document I have a raw data sheet and a calculation sheet. The calculation sheet i...
To me, this seems like a bug in the Forms-Excel integration. It's like the row from the sheet where the form data is added is being deleted and other sheets are accommodating this, but the row is then being populated with data. This looks like it has been a problem since 2019 as I found a post on Stack Overflow https://stackoverflow.com/questions/56962244/how-to-stop-microsoft-sheets-from-skipping-a-row-with-my-formula-when-a-new-answ. Effectively you have to create your formulas without direct range references to the main sheet.