*English follows Japanese

■Title(件名)：
Microsoft Forms で回答を削除した場合、OneDrive for Business に反映させる方法について

Reflect the deletion of responses in Microsoft Forms automatically to the “Forms for Excel” files.

■Description(内容):
現在、OneDrive for Business から [新規] - [Excel 用 Forms] でフォームを作成している。
Microsoft Forms から、[結果の表示] から回答を削除、もしくは [すべての結果を削除] とした場合、OneDrive for Business の Forms の Excel ファイルに反映されない。
OneDrive for Business から該当の Forms の Excel ファイルを開くと、削除したはずのデータもそのまま表示されている。
[すべての回答を新しいブックへ同期する] を行うと 削除が反映される動作になる。
しかしながら、現在、OneDrive for Business の Forms の Excel ファイルに関数を設定している為、[すべての回答を新しいブックへ同期する] を行うと新しいファイルが作成され、新たに関数を設定する必要がある。
関数を設定したファイルをそのまま利用する為、Microsoft Forms の結果を削除して、繰り返し同じフォームを利用したい。
Microsoft Form で削除した結果を OneDrive for Business の Forms の Excel ファイルに自動で同期されるように改善を希望します。

Currently, we create forms by clicking [New] – [Forms for Excel] in OneDrive for Business.
However, even though we deleted the responses from [View Results] in Microsoft Forms (or by selecting [Delete All Results] option), the deletion will not be reflected on "Forms for Excel" opened from OneDrive for Business.
The deleted data will be still displayed when opening the "Forms for Excel" file from OneDrive for Business. We have to select [Sync all responses to a new workbook] option to reflect the deletion to the file.

Since we are setting functions to "Forms for Excel" files of OneDrive for Business, we have to set functions to the files again because the new files will be generated when selecting [Sync all responses to a new workbook] option.
We would like to re-use the same files with those functions set by deleting only the responses of Microsoft Forms.

Therefore, it will be great if the deletion from Microsoft Forms will be reflected on "Forms for Excel" files automatically.

Thank you for your consideration.

There needs to be way to export the results without Excel interfering with them. This could be CSV export, or give us the option to run the results through Excel's very good import function before displaying.

When opening the results in Excel online, Excel tries to be helpful and automatically interprets some fields. The most destructive is where Excel decides that something is a date. Once it's decided my data is a date, I don't seem able to get the original text value back.

The results are inconsistent and seem to default to US date interpretation, for example:
"1 - 2" is converted to 02-Jan (even though my locale is UK)
"11 - 50" is converted to Nov-50

I have had to rearrange the question order in my Form when creating a survey, yet when I open the Form in Excel the columns are in completely the wrong order, and there are even blank column headers rather than questions.

I have tried to move the columns around on the Excel sheet, but keep receiving an error message. I have tried 'Refreshing all connections' to see if that rectified the issue, but have has no success.

There either needs to be a live refresh built into Forms for Excel, or there should be an option to be able to refresh the connection.

I am really disappointed, as I spent a long time creating the Form and now feel that in its current state in is unusable and will need to be created again.

Please rectify this issue.

*English follows Japanese

■Title(件名)：
OneDrive for Business からフォームのファイルを開くと、読み取り専用のコピーが表示される

Allow users to open Excel files in edit mode on OneDrive for Business

■Description(内容):
OneDrive for Business から Excel 用 Forms を作成した場合、ユーザーが回答を送信すると 5 分間 Forms の Excel ファイルを編集モードで開くことができない。
ユーザーがアンケートに回答後、 5 分間の間に該当のファイルを開くと
"このファイルは、SharePoint アプリによって編集がロックされています"
"読み取り専用のコピーを表示する"
"ファイルのコピーを保存して編集する"
と表示される。

ユーザーが回答を送信した直後であっても、編集モードで Forms の Excel を編集モードで表示できるように改善を希望します。

Currently, users are unable to open Forms for Excel file in edit mode for 5 min after users send a response to a survey when we create Forms in Excel on OneDrive for Business where simultaneous editing is disabled.
User get error (see below) if they try to open applicable files in that 5 min after replying to a survey
"This file is locked for editing by the SharePoint"
"Display a read-only copy"
"Save and edit a copy of a file"
For improvement of usability and manageability, we would like to open excel files in edit mode right after users respond to a survey.

Thank you for your consideration.

*English follows Japanese

■Title(件名)：Microsoft Forms を特定の外部ユーザーと共同で編集する方法

Provide the availability of the Collaborate editing in Microsoft Forms with the specific external users.

■Description(内容):
Microsoft Forms は、現在、"リンクを持つすべてのユーザー" もしくは "組織内のユーザー" の 2 種類のみ選択可能な状態です。
特定のセキュリティグループを選択するなどして、一部の外部ユーザーのみ共有をし、フォームを作成、編集、URL を送信できるような機能の実装を希望します。​

Currently, we recognize the Microsoft Forms feature that we can select two types of user for "Anyone with a view link" or "People inside my organization" only.

In order to further improve usability, we hope the feature will be implemented that allows us to select specific security groups, select it to be shared for only to the specific external users, or create/ edit of forms freely as well as sending URLs.

Thank you for your consideration.