- #MY EXCEL KEEPS CRASHING AND LOSING DATA INSTALL#
- #MY EXCEL KEEPS CRASHING AND LOSING DATA CODE#
- #MY EXCEL KEEPS CRASHING AND LOSING DATA PLUS#
It IS still an issue inside our network HERE, ONSITE, ON LAN. You don't seem to be reading my issue correctly. I appreciate any help that anyone has and if I seem blunt I don't mean to be, just trying to fix the issue and have tried a decent amount of things so far. At home I would just tell her that it would be connection and she would have to deal with a bit slower work flow but the big problem is when she needs the faster workflow here inside our network and it is still doing it, then it start to become a bigger problem. The files she opens have minimal to zero macros, scripts, or links.
#MY EXCEL KEEPS CRASHING AND LOSING DATA PLUS#
I want the reinstall to be a last resort as she is busy constantly and hindering her work would halt a decent amount of operations, plus re-setup of specific systems she uses would take more time as well. The first issue mentioned in the first paragraph is mostly solved, was just curious. Just to clarify I am speaking on the opening multiple files issue with the estimator. It has not been a problem for the past 3 months on this computer and has never happened on the other computers. The other thing being that i proceeds to happen here at work as well directly connected to our network where everything is stored. The only things that go against that are that we have a lot of these connections 40+ a day from other users and nobody else has issues and in fact are farther away.
![my excel keeps crashing and losing data my excel keeps crashing and losing data](https://www.partitionwizard.com/images/uploads/articles/2020/09/excel-keeps-crashing/excel-keeps-crashing-thumbnail.jpg)
I usually agree about latency over the VPN connection. The addins are the same as other users who haven't had any issues and we have also confirmed that it happens without any of the addins as well. This is the 32bit version but she has not hit the ram limit and uses minimal amounts of macros and no scripts.
#MY EXCEL KEEPS CRASHING AND LOSING DATA INSTALL#
Basically this is the internet install not the offline copy (which we don't have access to). This is Office 365 Business, we have a whole admin account that creates users and hands out licenses. At this point any help would be great, as she has a lot of work to do and it hinders the speed at which she can get work done. I have tried a few different fixes involving excel settings and none of them have worked. No settings in excel have change and none have changed on the computer itself. This is happening at home and here at work as well. If she opens any other excel file from the network, excel freezes and restarts and proceeds to open another blank document on top of trying to recover the current file. What has started to happen is since the first time she took it home, any time she opens an excel file from the network, she is limited to one. She has a good internet connection from home as well. This is something we do across the company and have not had issues at all. She has started working from home as she has moved into this position not that long ago and has had to VPN into our network from home. She is connected via Ethernet to the network and not WiFi. This is a laptop but it is a powerful one and not something that can't handle having many items open. She has had upwards of 7-8 excel documents open at once from the network and never had an issue before. We have a user that is one of our estimators and she opens a lot of files from our network. Has anyone else have excel freeze and require a restart to use again just from opening files from the network? But that is another issue which may lead to the current one which is more pressing. They would prefer you use onedrive or sharepoint. We did a little research and found that excel doesn't fully support opening from network drive. We have rooted that issue down to multiple people trying to access it. i am using cutcopy = False.We have ran into issues with Excel randomly freezing at least twice a week when opening files from a network drive. The problem also occurs in a nother part of the code, whenever i try to copy-paste >100 rows excel seems to freeze.
![my excel keeps crashing and losing data my excel keeps crashing and losing data](https://www.getdroidtips.com/wp-content/uploads/2021/12/2021-12-12-11_53_00-Greenshot.jpg)
TopLeftCell.Left + (.TopLeftCell.Width. TopLeftCell.Top + (.TopLeftCell.RowHeight.
#MY EXCEL KEEPS CRASHING AND LOSING DATA CODE#
The code below is causing the freeze, basically each picture after row 6 needs to be resized.
![my excel keeps crashing and losing data my excel keeps crashing and losing data](https://www.repairmsexcel.com/blog/wp-content/uploads/2018/09/Excel-not-responding.png)
How does it come I can only run it once? Is it a cache issue or something? I am already using compressed pictures and application.screenupdating & enablevents = false.
![my excel keeps crashing and losing data my excel keeps crashing and losing data](https://www.supereasy.com/wp-content/uploads/2018/11/img_5bff9471adafd.png)
I was wondering if it's a clipboard issue, but that is not the case. When I copy fewer lines, it stays stable. Therefore the code takes a while to complete and when I try to run it again, Excel completely freezes and I have to force a shut down on it. The problem is that each line contains a picture, which makes it quite a large file, up to 30mb. I am running a macro which copies data to another workbook and automatically saves this workbook.