Forum Discussion
Excel file too large
Windows 10, Microsoft 365 for Business - I have an excel workbook that is 58 mg and I've tried to share as attachment, as a link, OneDrive, SharePoint, internally and externally and no one can open i...
Karenmentions5 Depends on what the final goal is.
Is there any excess data (rows/columns) that can be deleted (ie. any data that formulas are not referencing?)
You can Save As the file to a binary sheet (.xlsb) to reduce the file size if it has a lot of data.
You can utilize Power Query to manage your data ETL (extraction, transforming, loading) process if the file is expected to continue growing.