Migration Assessment Scan: Large Excel Files

Learn how to mitigate issues with large Excel files during migration.

Overview

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 files will be migrated.

Important: 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

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     This scan report contains all the XLSX files that are over 10MB in size.

Column

Description

SiteId

Unique identifier of the impacted site collection.

SiteURL

URL to the impacted site collection.

SiteOwner

Owner of the site collection.

SiteAdmins

List of people listed as site collection administrators.

SiteSizeInMB

Size of the size collection in megabytes [MB]

NumOfWebs

Number of webs that exist in the site collection.

ContentDBName

Name of the content database hosting the site collection.

ContentDBServerName

SQL Server hosting the content database.

ContentDBSizeInMB

Size of the content database hosting the site collection.

LastContentModifiedDate

Date/Time the site collection had content modified.

TotalItemCount

Total number of items found in the site collection.

Hits

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.

DistinctUsers

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.

DaysOfUsageData

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

URL to the XLSX file.

FileSizeinMB

Size of the XLSX file in MB.

ScanID

Unique identifier assigned to a specific execution of the SharePoint Migration Assessment Tool.

Expand your skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×