•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Excel file crashes when checking a segment's box
Our take
Hello everyone, I’m using Excel 2016 to manage a workbook with approximately 2,000 rows and 20 columns, featuring four tables extracted via Power Query on separate sheets and around eight pivot tables linked to these queries, alongside several graphs. I’ve encountered frustrating crashes that occur intermittently when I click a button on a segment, causing the file to reload. I’m seeking insights into the potential causes of these crashes and suggestions for improving the file's performance. Thank you for your help!
Hello everyone,
I'm on excel 2016 and I have an excel workbook with a database of around 2000 rows and 20 columns, 4 tables extracted with PQ each one in a sheet, 7 or 8 pivot tables referencing these queries with the same number of graphs.
Sometimes (not every time) the file crashes and reloads itself when I click on a button on a segment and it's frustrating. What could cause that and how can I improve my file?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- File taking to long to load/crashingHello! I'm hoping someone can help me or maybe even point me in the right direction. At work we have an excel file that has tons of formulas, data, as well as pivots but seems to be getting to the point of crashing often and taking a while to open the file does anyone have any tips on how to scale it back down to where it's manageable? submitted by /u/Past-Kale-6616 [link] [comments]
- Why does power query crash after loadingI have a power query workbook that does quite a few extensive transformations (takes a minute or so to load) But then is fine But sometimes like 20 mins later the file crashes despite not actually running anything anymore Why does this occur? submitted by /u/Falconflyer75 [link] [comments]