User Profile
lousse
Copper Contributor
Joined 5 years ago
User Widgets
Recent Discussions
Re: Forms responses missing when Excel is opened
Stephanie Piazza I posted a solution back in May on this thread but it seemed to have disappeared. Here is a summary. I had the same problem with 50% of the responses missing. The best way to maximize your chances to have all your responses in your Excel is to have two excel documents. One document for the data and one for the processing of the data. The reason is that Excel tries to calculate every formula each time forms add a response. It can take a long time especially if you have a lot of formulas (I had 1000 complex formulas referencing the data). Forms is like a user, it tries to add data but if the document is calculating or blocked by another user it gives up. You then end up with missing data. Having a document for data allows forms to input data without being stuck by excel calculating or another user modifying the document. Excel will only try to calculate formulas when you open the processing document containing the formulas. It's also a great way to change your data document if needed. With this, I nearly never had missing data. Hopes it helps.2KViews0likes3Comments
Recent Blog Articles
No content to show