How to stop Excel Online from being so slow?
Our take
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.
[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]
- Online spreadsheet stuck on loading screenI've been making a budget tracker for myself using Excel online. I've spent quite a bit of time setting it up, I've tried to add a couple charts to visualise the data but as soon as ive selected an entire column as a data source (it only has 10 values in it so far) it crashes the entire spreadsheet and it gets stuck infinitely loading. This is now the third time I've had to recreate it from scratch due to issues around charts. Is there any way I can get it to load or do I just need to give up using excel. submitted by /u/GhostDog_1314 [link] [comments]
- Slow spreadsheet - need troubleshootingHi, I have a spreadsheet that has two tabs, one is essentially the original data which is YTD driven for a particular GL account, the company has smaller amounts of transactions, so by December we are talking about maybe 3-5k rows of transactions for the account total. The main tab being utilized, has about 30 columns of look up and sumifs formulas referencing the source data and in total approx maybe 500 rows by year end? To me it doesn’t seem excessive. I’ve dealt with way heavier spreadsheets that have more omph and run faster. But for some reason this one is slow as all hell to work in. I’ve even tried barcoded some data and not seen any improvement. I’m not too techy into what else could be slowing it down. And ideas on what to troubleshoot from here? submitted by /u/SlideTemporary1526 [link] [comments]
- Excel Online stuck in reload cycle, over and overTrying to use Excel Online for a quick data import. When launching the online page, it is cycle loading the first page over and over, with the logo appearing as a small block... flashing with the page load. Other 365 online apps load fine. Using Edge on Windows 10. Anyone seen this before? submitted by /u/KhakiMan [link] [comments]