•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
excel suddenly became very slow and clunky today
Our take
If you're facing unexpected sluggishness when reopening existing Excel files, you're not alone. Users often report a lag that disrupts productivity, particularly after saving and reopening documents. Despite new workbooks functioning smoothly, the issue may arise from factors beyond file complexity, as even new, blank files can exhibit this behavior. You've already taken steps to optimize performance by disabling features like Co-Pilot and Auto Save. Let's explore potential solutions to restore efficiency and enhance your overall Excel experience, allowing you to work seamlessly.
this lag happens only when i open an existing file in my local system.
when i open a new workbook, it works fine and without that sluggish lag, however the moment i save it onto my pc, and re-open, there is a lag sort of like a slow motion effect that is really bugging and slowing down my work performance.
settings i have turned off:
co -pilot
auto save off
turned off 'enable background error checking'
i am not sure whats going on, this is not a big workbook/many formula kind of issue as even a brand new blank file which i save, it becomes lag afterwards
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- A new workbook saved to a sharepoint is excruciatingly sluggishI create a book1.xlsx and it's blank, save it to my desktop and it works as expected. Changing cells is instantaneous. Typing in a cell is instantaneous. Hitting enter to finish editing that cell is also instantaneous. Then I save it to our organizations SharePoint, which happens to be overseas. Suddenly, every action is met with nearly half second lag. I can start typing in a cell at a normal speed and it lags, characters show up in chunks as I type. Even single-clicking on different cells is met with lag. This is in the desktop excel, not web based. Why is this happening? Every online resource tells me I have too much data, too complex of a formula, but there is none of that in here. When I open an excel file from a sharepoint it's supposed to put it on my local machine, and then upload changes as I make them in the background. It's worked flawlessly for years. Now that this SharePoint is based overseas it becomes a sluggish nightmare from the get-go. Is there something I can do to stop this behavior? Turning off autosave does not work. submitted by /u/fixthe_fernback [link] [comments]
- How to stop Excel Online from being so slow?Since an update a few years back, I want to say two or three (it was some UI changes mostly) my Excel Online has just been unbearably slow. Just a few minutes ago I added a new sheet to an existing file. For some background it was previously a single sheet 13x47 table with 2 columns of simple calculations (one adding up a couple columns, and another doing some division), 282 cells being used. The new sheet took 2 minutes to process and actually be created. It is currently a 6x21 table, but by the time I created the 3rd of 6 columns it froze and had an error then reloaded itself putting me back to only 2 columns made. It did this again then 3 times more before I finished the table, each time taking several minutes. There is not a lot of data in the file, there's simple calculations without function calls, and I have no issues with my internet connection. I could make a new file and still have the same issues. I often have to reload a file 10+ times before I can complete some simple data entry. I do know there's a banner that pops up from time-to-time about my internet settings but clicking the hyperlink that comes with it just crashes the file again. I also know that Firefox (the browser I use) will occasionally try to get me to close the page because it's lagging out so bad. Lastly, the files work fine on my phone browser. Anyone know what could be causing this? Because at this point it's honestly faster to use pen and paper if not for the fact I already have all the old data online. submitted by /u/AltoniusAmakiir [link] [comments]
Tagged with
#big data performance#Excel compatibility#rows.com#Excel alternatives for data analysis#Excel alternatives#AI formula generation techniques#big data management in spreadsheets#formula generator#Excel#lag#slow#performance lag#workbook#save#local system#re-open#sluggish#performance#blank file#issue