•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
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]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#financial modeling with spreadsheets
#rows.com
#real-time data collaboration
#real-time collaboration
#Excel
#workbook
#pivot tables
#crashes
#database
#tables
#segment
#rows
#columns
#PQ
#queries
#graphs
#Excel troubleshooting