•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
My excel file is now 11mb deleting a row of data now takes 20 mins
Our take
Struggling with a bloated Excel file that takes ages to process simple tasks? You’re not alone—many people face the frustration of slow performance when managing large datasets, especially in HRIS applications. Fortunately, AI-native spreadsheet technology offers a smarter solution that streamlines data management and enhances productivity. Imagine quick edits and instant formula updates, all without the lag. Keep reading to discover how you can transform your spreadsheet experience and reclaim valuable time in your day-to-day operations.
My file is now big to delete a single row of data that formulas. The file serves as HRIS so.. it's so fucking frustrating to do job. I tried converting it into xlsb format but it's still lag
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- What actually slows Excel down the most in real work?I work in logistics and use Excel every day. I noticed that many people struggle with slow files, lag, and crashes. In your experience, what is the most annoying issue with Excel? - slow formulas? - too much data? - file size? - something else? Trying to understand real problems people face at work. submitted by /u/ChargeSufficient4735 [link] [comments]
- Excel Size Issue 60MB XLSXI 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? submitted by /u/Darknight296 [link] [comments]
- Rows in file not getting deletedI am working on a data set where suddenly I am unable to delete few rows in between. As in only the data in the cells are getting deleted but the empty row is still present. Tried ctrl & -, manually deleting, tried converting to table and deleting. Tried all methods suggested by chat gpt and co pilot. This is a simple data set with values in general, text, number and date format. What is irritating is this is affecting all the other sheets in the same file. The only alternative solution now which is working is copying the entire data set everyday to a new sheet and then reworking. Can anyone explain why exactly this is happening. Been working with excel for few years and being unable to find the exact RCA is ruining my peace. Update: Unable to add rows as well. submitted by /u/dex_lab [link] [comments]
- I have a problem when trying to delete rows on a table.When i filter my table and i wanna delete multiplte rows at the same time excel beggin to lag and i cant even delete any fkin row . Know that i m filtring the table by multiple standard year 2024 to delete old data and another data so do yu have a solution please submitted by /u/Beautiful-Seat-8190 [link] [comments]