Problem with Forms for Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-3302308%22%20slang%3D%22en-US%22%3EProblem%20with%20Forms%20for%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3302308%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20are%20using%20multiple%20forms%20created%20by%20Sharepoint%20Online's%20document%20library%20(Forms%20for%20Excel).%20We%20noticed%20at%20monday%2C%20that%20when%20accessed%20by%20link%2C%20all%20forms%20gives%20an%20error%20message%20%22Problem%20viewing%20survey...%22.%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20appears%20for%20every%20user%20(including%20guest%20users%20outside%20organisation).%20Also%20on%20every%20browser.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20we%20go%20to%20check%20Excel-file%20linked%20to%20form%2C%20it%20opens%20as%20broken.%20When%20fixed%2C%20form-part%20of%20the%20file%20is%20removed%20(%2Fxl%2Fsurveys%2Fsurvey1.xml).%3C%2FP%3E%3CDIV%20class%3D%22%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20new%20Forms%20for%20Excel%20is%20created%2C%20it%20works%20while%20file%20is%20open.%20But%20when%20accessed%20by%20link%2C%20form%20gives%20same%20error%20message.%20And%20when%20file%20is%20opened%20again%2C%20it%20is%20broken%20and%20form%20is%20removed.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20could%20have%20caused%20this%3F%20Is%20there%20a%20fix%20for%20it%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOriginal%20error%20messages%20are%20in%20Finnish%2C%20I%20hope%20they%20are%20translated%20well%20enough.%3C%2FP%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3302308%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3322600%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20Forms%20for%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3322600%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1380726%22%20target%3D%22_blank%22%3E%40vkjkl%3C%2FA%3E%26nbsp%3BI%20am%20facing%20the%20exact%20same%20issue%20as%20you%20described.%20First%2C%20an%20existing%20survey%20broke%20for%20my%20client%20after%20I%20opened%20and%20closed%20the%20workbook.%20Then%20even%20when%20I%20upload%20a%20new%20excel%20file%20and%20create%20a%20fresh%20survey%2C%20the%20excel%20file%20is%20broken%20after%20I%20reopen%20it%20and%20the%20technical%20details%20say%20that%20the%20survey%20was%20removed%20in%20order%20to%20repair%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3332947%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20Forms%20for%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3332947%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1380726%22%20target%3D%22_blank%22%3E%40vkjkl%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ewe%20have%20the%20exact%20same%20problem%3C%2FP%3E%3CP%3Ealso%20started%20a%20few%20days%20ago%3C%2FP%3E%3CP%3Eit%20concerns%20old%20Excel%20files%20with%20surveys%2C%26nbsp%3Bon%20a%20Sharepoint-site%3C%2FP%3E%3CP%3Esurveys%20were%20created%20before%20Forms%20were%20used%20for%20this%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi,

 

We are using multiple forms created by Sharepoint Online's document library (Forms for Excel). We noticed at monday, that when accessed by link, all forms gives an error message "Problem viewing survey...". 

This appears for every user (including guest users outside organisation). Also on every browser.

 

When we go to check Excel-file linked to form, it opens as broken. When fixed, form-part of the file is removed (/xl/surveys/survey1.xml).

 

If new Forms for Excel is created, it works while file is open. But when accessed by link, form gives same error message. And when file is opened again, it is broken and form is removed.

 

What could have caused this? Is there a fix for it?

 

Original error messages are in Finnish, I hope they are translated well enough.

2 Replies

@vkjkl I am facing the exact same issue as you described. First, an existing survey broke for my client after I opened and closed the workbook. Then even when I upload a new excel file and create a fresh survey, the excel file is broken after I reopen it and the technical details say that the survey was removed in order to repair it.

@vkjkl 

we have the exact same problem

also started a few days ago

it concerns old Excel files with surveys, on a Sharepoint-site

surveys were created before Forms were used for this