Report erasing data in a sheet


I have a report running to track changes across multiple sheets. When data is added to the sheet, I see that change in the report as expected. However, when I remove data from the report, it also removes data from the sheet that it is looking at. Is there a way to prevent this? I do not want to remove data from the report and it remove that same data from the sheet.


  • Mike Raposo
    Mike Raposo ✭✭✭✭


    Changes to data in a report will always be reflected on the source sheet as they are connected in real time. There is currently not a way to make changes to data on a report without affecting the source sheet.

    You may want to consider adjusting the filter criteria of your report so that it filters out rows from the report based on certain conditions, instead of removing data from the report that affects the source sheet.

    Hope this helps! Let me know if you have questions.