- guest_22746346653055Asked on November 02, 2012 at 01:02 PM
I have a report built on my form, but when I export it through my reports tab, it will not export correctly. I have attached a picture of the statement that I am getting. Please help as we are on a time constraint with this report. Thank you.
- JotForm SupportDeygusAnswered on November 02, 2012 at 02:04 PM
Hi, if you are referring to the export Reports tab that is next to the submissions for your forms on your My Forms List Toolbar, I just tested this and it appears to be working properly on my end.
If the problem continues please try deleting the reports and making a new one to see if this helps correct your problem. Also I would like to recommend that you read the Generating an Excel Report guide incase you have not done so already.
If you are still having trouble beyond this then please let us know so that we can investigate it further.
- rwardaAnswered on November 02, 2012 at 02:31 PM
Hello, Thank you for your response. I may have not asked the question properly. I am able to export the spreadsheet, but when I am saving it or trying to open the spreadsheet, I am getting the error such as the attachment above. I deleted both reports I had and created a new one and still not working. I just tried it again and same thing happens. It is only happening on that particular form. It never gave us problems prior to this. Please help. Thank you.
- jeanettebmzAnswered on November 02, 2012 at 03:20 PM
That seems to be a security alert on Excel. Probably excel is not recognizing the validation. Or it is coming corrupt. You should just open it and instruct Excel to validate the file to avoid further warnings
- rwardaAnswered on November 02, 2012 at 03:47 PM
Hello and thank you for your response. I did instruct Excel to validate the file and I get the report but it says that "Excel recovered your formulas and cell values, but some data may have been lost". And yes, data is lost and probably only a quarter of the data is there.
- jeanettebmzAnswered on November 02, 2012 at 05:17 PM
Can you please send me the file to email@example.com with attention to me, so I can try to reproduce the error?
- rwardaAnswered on November 02, 2012 at 08:14 PM
I sent this to you earlier. Looking forward to your reply. Thank you.