•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Online spreadsheet stuck on loading screen
Our take
It sounds like you're experiencing frustrating issues with Excel Online while trying to create your budget tracker. When charts cause a spreadsheet to get stuck on the loading screen, it can feel disheartening, especially after investing time into setup. Before considering giving up on Excel, there are a few strategies you can explore to troubleshoot this problem. Simplifying your data sources, checking your browser settings, or even trying a different platform might help.
I'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.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- 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]
- Request for improved methodI work in accounts payable for a company and took over some additional duties a few months ago. One of those duties is keeping a tracker/log of all bills that come in. A tracker in excel was handed over to me. While I’ve improved many things with this tracker so far, I’m looking to make a major change but unsure how to go about it. This tracker has 110k rows of data and has columns with data up to column “FZ”. New rows of data are added daily. Old rows are “archived” as soon as possible. I’m no excel pro, but can hold my own and have learned along the way. Issue: large dataset presents challenges with excel freezing and/or crashing Disclaimer: I cannot remove any rows or columns. Question: is there a better way to handle this data? Ie. tools in excel, using something other than excel, etc? submitted by /u/Visible-Question-786 [link] [comments]
- Excel - Get Data - Access stuck on "Loading Data..."I have a workbook with multiple queries that pull data from Access queries and load to pivot tables. Most of them update/refresh fine, but several of them just spin and get stuck on "Loading data..." The query results are only like 10-20 rows for each of these that get stuck. The power query does no filtering/sorting or anything, I have no VBA doing anything, no macros, or conditional formatting. I'm clueless as to why some are fine and these others just get stuck. Help!!! TIA. submitted by /u/Good_Struggle_7471 [link] [comments]
- How to make Line Charts automatically not start from 0?Hi guys, I am working on a calculator made in excel. It pulls the data from one sheet and in another one it displays some kpi summaries, insights and line charts. I am not happy with how the line charts look like because it always starts from 0 and my line is sitting on the top third of the chart, while the bottom two thirds are just empty space. I tried a few things, such as adding helper columns in the chart and making them invisible, to automatically adjust it every time new data is uploaded but the min is always 0 and I have control over the max only, which lowers the position of the line but makes it even more straight so it's still unappealing. I do not want to use VBA as it's something we are sending to clients, and if they do not enable macros then it's for nothing. Are there any solutions you guys might know? I am using the desktop version of excel, on mac. Thank you submitted by /u/Think_Jello_8525 [link] [comments]
Tagged with
#Excel alternatives for data analysis#real-time data collaboration#generative AI for data analysis#Excel compatibility#Excel alternatives#big data management in spreadsheets#conversational data analysis#intelligent data visualization#real-time collaboration#data visualization tools#enterprise data management#big data performance#interactive charts#data analysis tools#data cleaning solutions#modern spreadsheet innovations#machine learning in spreadsheet applications#enterprise-level spreadsheet solutions#digital transformation in spreadsheet software#rows.com