I deleted some submission of a form using the Data Table window on kobo.humanitarianresponse.info. The deleted submissions were from a previous version of this form. The submissions were successfully deleted, as they no longer show up in the Data Table view.
I have an excel workbook which pulls data using Power Query from the server. However, these deleted submission continue to appear in my Excel workbook. What is the problem?
I am stuck and cannot proceed further in my analysis work? Kindly help.
This is because your Excel Dataset synced with KoBoToolbox requires manual refresh (to get the latest records from the server). Hence for this, press the Refresh All which you should see under the Data as shown in the image below:
Any potential tips on something you might have done to help make data disappear? I’ve tried a number of things including clearing my excel and web browser caches, but nothing seems to be working. Data still seems to be showing on my spreadsheet.