This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
We have a spreadsheet for 4 separate teams to report into on separate tabs. We have a list of projects which is being pulled from a data tab and between 10 and 30 people enter the individual team tabs to provide updates for each project. The issue seems to happen when two or more people to to enter in the specific spreadsheet. The data is either slipping down a row or jumping up a row dependent on where the next person amending their data is in the list. I have already locked the filter function to reduce this but we are still getting this issue.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Many Thanks Poonam Agnihotri but I have tried previously to run the spreadsheet as a table but it contains VSTACK formulas that then provide Spill errors when converted to a TABLE. I have as I said a DATA tab that I pull from onto each of the 4 tabs in order to maintain the same data across all tabs.