{"id":8364,"date":"2024-10-01T09:02:12","date_gmt":"2024-10-01T00:02:12","guid":{"rendered":"https:\/\/m365jp.net\/?p=8364"},"modified":"2024-10-01T09:15:46","modified_gmt":"2024-10-01T00:15:46","slug":"mc901820-microsoft-forms-new-data-sync-solution-for-microsoft-excel-for-the-web-in-microsoft-sharepoint-online-and-onedrive","status":"publish","type":"post","link":"https:\/\/m365jp.net\/index.php\/2024-10-01-mc901820-microsoft-forms-new-data-sync-solution-for-microsoft-excel-for-the-web-in-microsoft-sharepoint-online-and-onedrive","title":{"rendered":"MC901820 | Microsoft Forms: New data sync solution for Microsoft Excel for the web in Microsoft SharePoint Online and OneDrive"},"content":{"rendered":"
\n
\n
\n\n\n\n
MC901820 | Microsoft Forms: New data sync solution for Microsoft Excel for the web in Microsoft SharePoint Online and OneDrive<\/th>\n<\/tr>\n<\/tbody>\n<\/table>\n
\n\n\n\n\n\n\n\n\n
Classification<\/th>\nstayInformed<\/td>\n<\/tr>\n
Last Updated<\/th>\n09\/30\/2024 23:46:59<\/td>\n<\/tr>\n
Start Time<\/th>\n09\/30\/2024 23:46:47<\/td>\n<\/tr>\n
End Time<\/th>\n01\/15\/2025 08:00:00<\/td>\n<\/tr>\n
Message Content<\/th>\n\n

In July 2024, we communicated in MC816207 that Microsoft Forms supports live data sync to Microsoft Excel with more functionality. <\/p>\n

Coming soon: A new data sync solution with higher reliability to sync Forms response data to Microsoft Excel for the web. New Forms created from Microsoft OneDrive and Microsoft SharePoint online after this rollout will use the new data sync solution. <\/p>\n

[When this will happen:] <\/p>\n

General Availability (Worldwide): We will begin rolling out mid-October 2024 and expect to complete by mid-November 2024. <\/p>\n

[How this will affect your organization:] <\/p>\n

Before this rollout, Forms created from OneDrive and SharePoint Online used the old data sync solution. The Excel file was created automatically when creating the forms, and the Forms data was pushed to Excel file through Graph API. <\/p>\n

With this rollout, Forms created from OneDrive and SharePoint Online will use the new data sync solution. The Excel file will not be created automatically. The user can create the Excel file from the Forms result page after responses have been received. <\/p>\n

Workflow<\/i><\/p>\n

1. Create a new form from SharePoint Online or OneDrive for business: Select New > Forms survey<\/i> (before rollout, this was called Forms for Excel<\/i>). <\/p>\n

\"user <\/p>\n

2. After receiving responses to the form, create an Excel file from the Forms result page to sync the data: <\/p>\n

\"user <\/p>\n

3. The Excel file will be created in the SharePoint folder where the form was created. <\/p>\n

\"user <\/p>\n

Note: The new data sync can only be triggered in Excel for the web. If users want to receive new Forms response data in the Excel desktop app, open the file in Excel for the web, and then wait for the desktop app file to sync from the web file. (Support for other versions of Excel is in progress.)<\/p>\n

<\/p>\n

This feature will be on by default.<\/p>\n

[What you need to do to prepare:] <\/p>\n

This rollout will happen automatically by the specified date with no admin action required before the rollout. You may want to notify your users about this change and update any relevant documentation. <\/p>\n

Learn more: Create a form with Microsoft Forms – Microsoft Support<\/a> (will be updated before rollout begins)<\/p>\n

<\/p>\n

<\/p>\n

<\/p>\n<\/td>\n<\/tr>\n

Machine Translation<\/th>\n\n

2024 \u5e74 7 \u6708\u306b\u3001Microsoft Forms \u304c Microsoft Excel \u3078\u306e\u30e9\u30a4\u30d6 \u30c7\u30fc\u30bf\u540c\u671f\u3092\u30b5\u30dd\u30fc\u30c8\u3057\u3001\u3088\u308a\u591a\u304f\u306e\u6a5f\u80fd\u3092\u5099\u3048\u3066\u3044\u308b\u3053\u3068\u3092 MC816207 \u3067\u304a\u77e5\u3089\u305b\u3057\u307e\u3057\u305f\u3002<\/p>\n

\u8fd1\u65e5\u516c\u958b\u4e88\u5b9a: Forms \u306e\u5fdc\u7b54\u30c7\u30fc\u30bf\u3092 Web \u7528\u306e Microsoft Excel \u306b\u540c\u671f\u3059\u308b\u305f\u3081\u306e\u3001\u4fe1\u983c\u6027\u306e\u9ad8\u3044\u65b0\u3057\u3044\u30c7\u30fc\u30bf\u540c\u671f\u30bd\u30ea\u30e5\u30fc\u30b7\u30e7\u30f3\u3002\u3053\u306e\u30ed\u30fc\u30eb\u30a2\u30a6\u30c8\u5f8c\u306b Microsoft OneDrive \u304a\u3088\u3073 Microsoft SharePoint Online \u304b\u3089\u4f5c\u6210\u3055\u308c\u305f\u65b0\u3057\u3044\u30d5\u30a9\u30fc\u30e0\u3067\u306f\u3001\u65b0\u3057\u3044\u30c7\u30fc\u30bf\u540c\u671f\u30bd\u30ea\u30e5\u30fc\u30b7\u30e7\u30f3\u304c\u4f7f\u7528\u3055\u308c\u307e\u3059\u3002<\/p>\n

[\u3053\u308c\u304c\u3044\u3064\u8d77\u3053\u308b\u304b:] <\/p>\n

\u4e00\u822c\u63d0\u4f9b (\u5168\u4e16\u754c): 2024 \u5e74 10 \u6708\u4e2d\u65ec\u306b\u30ed\u30fc\u30eb\u30a2\u30a6\u30c8\u3092\u958b\u59cb\u3057\u30012024 \u5e74 11 \u6708\u4e2d\u65ec\u307e\u3067\u306b\u5b8c\u4e86\u3059\u308b\u4e88\u5b9a\u3067\u3059\u3002<\/p>\n

[\u3053\u308c\u304c\u3042\u306a\u305f\u306e\u7d44\u7e54\u306b\u3069\u306e\u3088\u3046\u306b\u5f71\u97ff\u3057\u307e\u3059\u304b:]<\/p>\n

\u3053\u306e\u30ed\u30fc\u30eb\u30a2\u30a6\u30c8\u306e\u524d\u306b\u3001OneDrive \u3068 SharePoint Online \u304b\u3089\u4f5c\u6210\u3055\u308c\u305f\u30d5\u30a9\u30fc\u30e0\u306f\u3001\u53e4\u3044\u30c7\u30fc\u30bf\u540c\u671f\u30bd\u30ea\u30e5\u30fc\u30b7\u30e7\u30f3\u3092\u4f7f\u7528\u3057\u3066\u3044\u307e\u3057\u305f\u3002Excel \u30d5\u30a1\u30a4\u30eb\u306f\u30d5\u30a9\u30fc\u30e0\u306e\u4f5c\u6210\u6642\u306b\u81ea\u52d5\u7684\u306b\u4f5c\u6210\u3055\u308c\u3001Forms \u30c7\u30fc\u30bf\u306f Graph API \u3092\u4ecb\u3057\u3066 Excel \u30d5\u30a1\u30a4\u30eb\u306b\u30d7\u30c3\u30b7\u30e5\u3055\u308c\u307e\u3057\u305f\u3002<\/p>\n

\u3053\u306e\u30ed\u30fc\u30eb\u30a2\u30a6\u30c8\u306b\u3088\u308a\u3001OneDrive \u3068 SharePoint Online \u304b\u3089\u4f5c\u6210\u3055\u308c\u305f\u30d5\u30a9\u30fc\u30e0\u306f\u3001\u65b0\u3057\u3044\u30c7\u30fc\u30bf\u540c\u671f\u30bd\u30ea\u30e5\u30fc\u30b7\u30e7\u30f3\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002Excel\u30d5\u30a1\u30a4\u30eb\u306f\u81ea\u52d5\u7684\u306b\u4f5c\u6210\u3055\u308c\u307e\u305b\u3093\u3002\u30e6\u30fc\u30b6\u30fc\u306f\u3001\u56de\u7b54\u3092\u53d7\u3051\u53d6\u3063\u305f\u5f8c\u3001\u30d5\u30a9\u30fc\u30e0\u306e\u7d50\u679c\u30da\u30fc\u30b8\u304b\u3089 Excel \u30d5\u30a1\u30a4\u30eb\u3092\u4f5c\u6210\u3067\u304d\u307e\u3059\u3002<\/p>\n

\u30ef\u30fc\u30af\u30d5\u30ed\u30fc<\/i><\/p>\n

1. SharePoint Online \u307e\u305f\u306f OneDrive for business \u304b\u3089\u65b0\u3057\u3044\u30d5\u30a9\u30fc\u30e0\u3092\u4f5c\u6210\u3059\u308b: [\u65b0\u3057\u3044 >Office \u30d5\u30a9\u30fc\u30e0] \u30a2\u30f3\u30b1\u30fc\u30c8<\/i> (\u30ed\u30fc\u30eb\u30a2\u30a6\u30c8\u524d\u306f Excel \u7528\u30d5\u30a9\u30fc\u30e0\u3068\u547c\u3070\u308c\u3066\u3044\u307e\u3057\u305f) \u3092\u9078\u629e\u3057\u307e\u3059 (\u30ed\u30fc\u30eb\u30a2\u30a6\u30c8\u524d\u306f [\u30d5\u30a9\u30fc\u30e0] \u3068\u547c\u3070\u308c<\/i>\u3066\u3044\u307e\u3057\u305f)\u3002<\/p>\n

\"user <\/p>\n

2. \u30d5\u30a9\u30fc\u30e0\u3078\u306e\u56de\u7b54\u3092\u53d7\u3051\u53d6\u3063\u305f\u3089\u3001\u30d5\u30a9\u30fc\u30e0\u306e\u7d50\u679c\u30da\u30fc\u30b8\u304b\u3089Excel\u30d5\u30a1\u30a4\u30eb\u3092\u4f5c\u6210\u3057\u3066\u30c7\u30fc\u30bf\u3092\u540c\u671f\u3057\u307e\u3059\u3002<\/p>\n

\"user <\/p>\n

3. Excel\u30d5\u30a1\u30a4\u30eb\u306f\u3001\u30d5\u30a9\u30fc\u30e0\u304c\u4f5c\u6210\u3055\u308c\u305fSharePoint\u30d5\u30a9\u30eb\u30c0\u306b\u4f5c\u6210\u3055\u308c\u307e\u3059\u3002<\/p>\n

\"user <\/p>\n

\u6ce8: \u65b0\u3057\u3044\u30c7\u30fc\u30bf\u540c\u671f\u306f\u3001Excel for the web \u3067\u306e\u307f\u30c8\u30ea\u30ac\u30fc\u3067\u304d\u307e\u3059\u3002\u30e6\u30fc\u30b6\u30fc\u304c Excel \u30c7\u30b9\u30af\u30c8\u30c3\u30d7 \u30a2\u30d7\u30ea\u3067\u65b0\u3057\u3044 Forms \u5fdc\u7b54\u30c7\u30fc\u30bf\u3092\u53d7\u3051\u53d6\u308b\u5834\u5408\u306f\u3001Excel for the web \u3067\u30d5\u30a1\u30a4\u30eb\u3092\u958b\u304d\u3001\u30c7\u30b9\u30af\u30c8\u30c3\u30d7 \u30a2\u30d7\u30ea \u30d5\u30a1\u30a4\u30eb\u304c Web \u30d5\u30a1\u30a4\u30eb\u304b\u3089\u540c\u671f\u3055\u308c\u308b\u306e\u3092\u5f85\u3061\u307e\u3059\u3002(\u4ed6\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u306e Excel \u306e\u30b5\u30dd\u30fc\u30c8\u306f\u9032\u884c\u4e2d\u3067\u3059\u3002<\/p>\n

<\/p>\n

\u3053\u306e\u6a5f\u80fd\u306f\u30c7\u30d5\u30a9\u30eb\u30c8\u3067\u30aa\u30f3\u306b\u306a\u3063\u3066\u3044\u307e\u3059\u3002<\/p>\n

\u3010\u6e96\u5099\u306b\u5fc5\u8981\u306a\u3053\u3068\u3011<\/p>\n

\u3053\u306e\u30ed\u30fc\u30eb\u30a2\u30a6\u30c8\u306f\u3001\u30ed\u30fc\u30eb\u30a2\u30a6\u30c8\u524d\u306b\u7ba1\u7406\u8005\u306e\u64cd\u4f5c\u3092\u5fc5\u8981\u3068\u305b\u305a\u306b\u3001\u6307\u5b9a\u3055\u308c\u305f\u65e5\u4ed8\u307e\u3067\u306b\u81ea\u52d5\u7684\u306b\u884c\u308f\u308c\u307e\u3059\u3002\u3053\u306e\u5909\u66f4\u306b\u3064\u3044\u3066\u30e6\u30fc\u30b6\u30fc\u306b\u901a\u77e5\u3057\u3001\u95a2\u9023\u3059\u308b\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u3092\u66f4\u65b0\u3059\u308b\u3053\u3068\u3092\u304a\u3059\u3059\u3081\u3057\u307e\u3059\u3002<\/p>\n

\u8a73\u7d30\u60c5\u5831: Microsoft Forms \u3067\u30d5\u30a9\u30fc\u30e0\u3092\u4f5c\u6210\u3059\u308b – Microsoft \u30b5\u30dd\u30fc\u30c8<\/a> (\u30ed\u30fc\u30eb\u30a2\u30a6\u30c8\u958b\u59cb\u524d\u306b\u66f4\u65b0\u3055\u308c\u307e\u3059)<\/p>\n

<\/p>\n

<\/p>\n

<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

MC901820 | Microsoft Forms: New data sync solution for Microsoft Excel for the web in Microsoft SharePoint Onl […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-8364","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/m365jp.net\/index.php\/wp-json\/wp\/v2\/posts\/8364","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/m365jp.net\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/m365jp.net\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/m365jp.net\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/m365jp.net\/index.php\/wp-json\/wp\/v2\/comments?post=8364"}],"version-history":[{"count":0,"href":"https:\/\/m365jp.net\/index.php\/wp-json\/wp\/v2\/posts\/8364\/revisions"}],"wp:attachment":[{"href":"https:\/\/m365jp.net\/index.php\/wp-json\/wp\/v2\/media?parent=8364"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/m365jp.net\/index.php\/wp-json\/wp\/v2\/categories?post=8364"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/m365jp.net\/index.php\/wp-json\/wp\/v2\/tags?post=8364"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}