移轉評估掃描:大型 Excel 檔案Migration Assessment Scan: Large Excel Files

了解如何減輕大型 Excel 檔案在移轉期間的問題。Learn how to mitigate issues with large Excel files during migration.

概觀Overview

在瀏覽器中開啟 XLSX 檔案的大小上限為 10 MB (以目標環境而定)。您可在來源環境中調整此設定,藉此為您的使用者變更系統行為。如果您嘗試從 SharePoint 網站開啟大於 10 MB 的檔案,系統會提示您在 Excel 用戶端應用程式中開啟檔案。The maximum limit for opening XLSX files in the browser is 10MB in the target environment. This setting is configurable in the source environment which may result in a change in behavior for your users. If you attempt to open a file larger than 10MB from a SharePoint site, it will prompt you to open the file in the Excel client application.

資料移轉Data Migration

系統將會移轉 XLSX 檔案。XLSX files will be migrated.

重要

任何設定為「無法存取」(鎖定) 的網站在 SharePoint 中都將予以略過。若要查看鎖定的網站集合清單,請參閱「鎖定的網站」掃描輸出。Any site that is configured as "No Access" (locked), in SharePoint will be skipped. To see a list of locked site collections see the Locked Sites scan output.

準備移轉Preparing for Migration

通知使用者預期的行為。Notify users of the expected behavior.

移轉之後Post Migration

嘗試開啟大於 10 MB 的 XLSX 檔案時,系統會提示您在 Excel 用戶端中開啟檔案。系統會以對話方塊向您發出提示。Attempting to open an XLSX file larger than 10MB will prompt you to open the file in the Excel client. You will be prompted with a dialog.

掃描結果報表Scan Result Reports

LargeExcelFiles-detail.csv 此掃描報表包含所有大於 10 MB 的 XLSX 檔案。LargeExcelFiles-detail.csv This scan report contains all the XLSX files that are over 10MB in size.

Column 描述Description
SiteIdSiteId
受影響網站集合的唯一識別碼。Unique identifier of the impacted site collection.
SiteURLSiteURL
受影響網站集合的 URL。URL to the impacted site collection.
SiteOwnerSiteOwner
網站集合的擁有者。Owner of the site collection.
SiteAdminsSiteAdmins
列為網站集合系統管理員的人員清單。List of people listed as site collection administrators.
SiteSizeInMBSiteSizeInMB
網站集合的大小 [MB]Size of the size collection in megabytes [MB]
NumOfWebsNumOfWebs
網站集合中存在的網站數。Number of webs that exist in the site collection.
ContentDBNameContentDBName
主控網站集合之內容資料庫的名稱。Name of the content database hosting the site collection.
ContentDBServerNameContentDBServerName
主控內容資料庫的 SQL Server。SQL Server hosting the content database.
ContentDBSizeInMBContentDBSizeInMB
主控網站集合之內容資料庫的大小。Size of the content database hosting the site collection.
LastContentModifiedDateLastContentModifiedDate
網站集合內容的修改日期/時間。Date/Time the site collection had content modified.
TotalItemCountTotalItemCount
網站集合中項目的總數。Total number of items found in the site collection.
HitsHits
記錄的網站集合要求數。以流量記錄服務的資料為主。流量記錄服務若已停用,此列會顯示 N/A。Number of requests logged for the site collection. Relies on data from the usage logging service. If the usage logging service is disabled this row will show N/A.
DistinctUsersDistinctUsers
存取網站集合的不同使用者數目。以流量記錄服務的資料為主。流量記錄服務若已停用,此列會顯示 N/A。Number of distinct users that have accessed the site collection. Relies on data from the usage logging service. If the usage logging service is disabled this row will show N/A.
DaysOfUsageDataDaysOfUsageData
流量記錄服務保留資料的天數。這是針對 Hits 和 DistinctUsers 提供的內容。例如,如果這個值是 14 天,Hits 和 DistinctUsers 就是過去 14 天的資料。Number of days the usage logging service retains data. This provides context for Hits and DistinctUsers. For example, if this is 14 days, the Hits and DistinctUsers data is for the last 14 days.
檔案File
XLSX 檔案的 URL。URL to the XLSX file.
FileSizeinMBFileSizeinMB
XLSX 檔案的大小 (MB)。Size of the XLSX file in MB.
ScanIDScanID
指派給特定 SharePoint 移轉評定工具執行的唯一識別碼。Unique identifier assigned to a specific execution of the SharePoint Migration Assessment Tool.