Excel crashing while in VR. Any ideas as to why?
Our take
I have a set of workbooks that are a set of TTRPG rules and character sheets (having all of the sheets in one workbook caused excel to continuously crash). This has been working fine but for no apparent reason a couple of days ago one of the workbooks just started instantly crashing the moment you do anything with it, and even if you don't do anything it'll crash within a few minutes, this then causes all of the open workbooks to freeze. Occasionally it'll go about 10 minutes before it crashes, but that is rare. Every time it crashes however it says the workbook is saving, which seems to be true since after you end task on it all of your changes seem to have been saved even up to right before the crash, but it isn't saving. I have left it a whole hour to see if it actually will save and it doesn't.
Strangely this behaviour only seems to happen when I am in VR. Outside of VR I can't get the error to occur, at least not yet, but it is guaranteed while I am in VR. I can't think of any reason why this would be. I use the VR so I can have more and larger screens that can be easily moved around, mostly the virtual desktop app for the quest 3, but it also happens when using steamVR to give you multiple windows too. If I am not in VR though the workbook is happy as a clam, no freezes, no crashes, just works fine.
I would like a fix as the whole reason for this is to allow me to play with a VR VTT while having a custom ruleset and such floating around me ready to use.
There aren't any scripts active on the workbook that causes the freezing, so it isn't to do with scripting as far as I can tell. And at least so far all of the other workbooks work fine, but since I can't tell why this one does not (it is a character sheet and identical to other character sheets). The issue first started to happen after I created a data validation dropbox that looked at another workbook, but i have since tried deleting all of the data validation drop boxes, and highlighting the entire sheet and selecting data validation (which it says will delete all data validation rules even though it doesn't seem to have done).
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Constant Freezing and CrashingHi everyone, Trying to troubleshoot a strange Excel issue affecting a number of users in our environment and I’m curious if anyone else has seen something similar. Users report that Excel will lock up when switching between applications or when copying between Excel workbooks. The freeze can last around 10–30 seconds, after which Excel either recovers or occasionally crashes completely. If excel recovers for several more seconds clicking a cell sometimes selects the wrong cell or highlights an entire range instead of the single cell that was clicked. For example, the user clicks one cell but Excel highlights several cells nearby. Maybe an issue with DPI scaling issues? Some environment details: Microsoft Excel (Microsoft 365 Apps for Enterprise) Monthly Enterprise Channel Most affected machines running version 16.0.19530.20226 Some users on 16.0.19426.20260 Mix of Windows 10 and Windows 11 The issue appears across different machines and hardware, including multiple laptop brands and models with both lower and higher specs, so it doesn’t seem to be related to performance. It also doesn’t appear tied to workbook size as the issue happens with both small spreadsheets and larger ones. Resources look normal when the freeze occurs. Typical triggers seem to be: copying between Excel workbooks switching between Excel and another application (browser, Outlook, etc.) returning focus back to Excel Files are opened from a mix of locations: OneDrive SharePoint OneDrive SharePoint sync folders local files Users are working on laptops connected to external monitors, usually with the laptop screen still open as well. Some setups do have mixed display scaling (e.g. laptop at 150% and monitor at 100%) which could be causing the crashes? Things we’ve already tried: disabling hardware graphics acceleration disabling Live Preview disabling background error checking setting Excel to power saving GPU mode in Windows graphics settings testing across different machines and workbooks The issue appears specific to Excel, since other applications on the same machines don’t show similar freezing or input issues. Has anyone run into something similar with recent Microsoft 365 builds or seen Excel behave like this when switching between apps? Any suggestions for additional things to test would be really helpful. I am loosing my mind. submitted by /u/Any-Ticket4332 [link] [comments]
- My Workbook Has Too Much Going On And Keeps Freezingtl;dr I have my workbook doing too much across several sheets and it freezes for too long, anything I can do to fix it? I am a Customer Services manager for a local pest control company, so I am in charge of the team that makes the schedules. In order to check for scheduling errors, I have found a way to generate reports from our CRM and use Excel to find errors. In the past, I simply generated these reports, sorted through the data myself and gotten the results I wanted. It was great proof of concept, but I wanted to automate it for my convenience and so others who don't know the process can use it when I am unavailable. I was able to make a workbook that would take a list of services due in a month and a list of services scheduled for a day, sort, combine, filter, etc. to produce a list of services scheduled that need another service with it, or where a reservice (extra service requested by a client) is scheduled when a maintenance (services automatically due periodically) is due, so the reservices should just be changed to the maintenance. The problem is that whenever I add/remove the data from those reports, Excel freezes for like 5 minutes while it tried to do all that work. It's better than nothing, but I'd like to find a way for it to not do that, at least not for more than a minute or so. Here is are some details of my Workbook: From our CRM, I generate a report of all services due this month and a report of all services scheduled for the next day. I delete irrelevant columns until I am left with these, in this order: For services due: Customer ID (number unique to each account) Last Name (customer name) First Name (customer name) Subscription Status (will always be "Active") Subscription type (text) Service Due (current due date for the service) For services scheduled: Customer ID (number unique to each account) Last Name (customer name) First Name (customer name) Serviced By (technician assigned to appointment) Service type (text) Scheduled for (date appointment is for) I take each report and put them each into their own sheet in my work book ("SubsDue" and "Scheduled"). Both sheets will have the same number of columns and are in this order to match up intentionally. There can be over 15000 total services due in a month, so I have the sheet work with A2:F200000 to ensure it all fits. Row 1 is always just column headers that do not change. There's a helper column on 2-3 sheets as well, uses COUNTIF to check for duplicate Customer ID's, which is important. I then have it sorting through the data for these sheets by using VSTACK and FILTER to add the data to a new sheet, which will then be used again by even more sheets. Ultimately, I will have 2 sheets at the end that will only have the erroneous services I'm looking for. The sheet does this just like I expect it to, it just freezes up for 5 minutes or so while doing it. Here are a couple examples of the formulas my sheets are using: =FILTER(VSTACK(Scheduled!$A$2:$F$200000),NOT(VSTACK(Scheduled!$E$2:$E$200000)="Reservice")) (Takes the data from another sheet and shows only the Reservices included in it) =FILTER(VSTACK(SubsDue!A2:A200000,ReservicesScheduled!A2:F200000),VSTACK(SubsDue!A2:A200000,ReservicesScheduled!A2:A200000)>0) (Combines the data from 2 sheets and excludes the empty rows form each of them) I've been using Excel at a basic level for years and have learned a little more about it recently, but I don't know what to do to help with this. I can only imagine that having a chain of multiple sheets simultaneously using these formulas on up to 400000 rows at a time is just too much for Excel to handle without freezing up. Any recommendations for how I can improve this? I'd appreciate any help and would love to learn from this. Excel version is 16.0.19725.20152 submitted by /u/Royal-Advantage2706 [link] [comments]