•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Excel Size Issue 60MB XLSX
Our take
Struggling with a hefty 60MB Excel file that’s causing sync issues during live collaboration? You’re not alone. Many teams face the challenge of managing large spreadsheets, and while converting to XLSB can help, it sacrifices real-time collaboration. Luckily, there are effective strategies to trim down your file size without compromising functionality. In this guide, we’ll explore practical tips to streamline your Excel workbook, ensuring smoother teamwork and better performance. Read on to discover solutions that can enhance your collaborative experience and reduce frustration.
I have an Excel file with multiple people collaborating on it live, it currently sits at 60MB in XLSX format and when turned into XLSB it’s reduced to 37MB but with XLSB live collaboration is not available . At 60MB for people work on the file simultaneously there’s a lot of sync issues, so I need a way to at least reduce it by a few MB. I’ve deleted rows, there’s no Pivot tables, there’s a bunch of tabs and a lot of formulas. Any size reduction tips?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- How to reduce Excel file size when using PP and PQ?I am using excel to combine other excel files and to do calculations on them, including average, std, but also more personalised equations (hence PP). Specifically, the purpose is to have "database" because I work with a lot of csv and excle files that I constantly need too extract information from (e.g. 50 files in all of which I only need 2 columns in 4th sheet), pain without PQ. Currently I am doing "create connection only" when loading queries, and I retrieve them using pivot table with filters, so at no point all of the information is retrieved. I am not sure what else I can do to reduce file size/improve performance. Current file size is about 55Mb, which is a lot. submitted by /u/3and12characters [link] [comments]
- What are the best techniques for optimizing Excel performance with large datasets?I've been working with large datasets in Excel, and performance has become a significant concern. As the size of my spreadsheets grows, I've noticed slower load times and lag when applying formulas or filters. I'm keen to hear from the community about the best practices for optimizing Excel performance. Specifically, what strategies do you employ to manage large datasets effectively? Are there particular functions or features that help speed up processing? I've experimented with reducing volatile functions and minimizing the use of whole column references, but I'm eager to learn more. Also, how do you handle data organization to ensure that your workbooks remain responsive? Any tips on structuring data or using tools like Power Query would be greatly appreciated. Looking forward to your insights! submitted by /u/beachlady38 [link] [comments]
- NEED ADVICE re serious issues on collaborative company workbook. Appealing to Reddit's Excel wizards as a last resort.I work as part of a small team sharing an Excel workbook with my associates. The document is integral to company operations and requires continuous updating on multiple fronts. It is very large (7MB) and extremely complex, with about a dozen sheets using complex, interrelated formulas. There are up to four people on the document at any one time, with two of them making constant edits and using heavy filters throughout the day and the other two primarily just filtering for key items to inform business decisions. All four usually operate from different locations, sometimes across the country. We recently expanded the operations team from one to two people, since which time the document has been experiencing significant issues—none of which occurred prior to the new associate joining. These issues appear to stem from the new situation of having two people editing simultaneously for the first time, and include: Merging problems Regular crashes Filtering issues, such as when we are both filtered within the document and one person uses control+D to fill down in a filtered column, other rows that the one person’s filters do NOT show in that moment have been filled in as well. The workbook is stored on OneDrive but accessed and edited through the desktop Excel application with AutoSave enabled. Surely we are not the first business to face this issue. Are there any solutions we may be overlooking? How have other businesses approached such matters? It is imperative that the workbook remain updated in real-time for all involved for business purposes. Finally, please let me know if any other subreddits or communities (perhaps discord?) come to mind where I may find answers to the above. submitted by /u/LingeringOdor [link] [comments]