Aug 17 2020 05:16 AM - edited Aug 17 2020 07:41 AM
I'm using Windows 10 pro and Microsoft Office Professional 2019. I scan in information into Excel using a QR code. Once the information is in there I'm often times changing the colors of the cells. Almost daily when I change a color it completely locks up. It locks up that document and any other Excel document I have open. This usually lasts a couple of minutes before it unfreezes. HELP!!!!!!!!!!!!!!
Aug 17 2020 05:26 AM
Aug 17 2020 07:41 AM
@NikolinoDE I just added a file so you can take a look. Thanks!!!
Aug 17 2020 08:59 AM
Aug 17 2020 09:06 AM
@JMB17 My thought was that it is this file as it is the only one it happens in. And always while I'm doing the same thing. I have a hard time replicating the issue also. When I have IT people around and try to show them I can never get it to do it. But it happens almost daily. Always while doing the same thing. Changing the color of a cell. I did the Com add ins a while ago while searching for solutions, it didn't help. Some of the formatting you are seeing is because I deleted some sensitive information. But I am going to clear the rest of it as you advised, thanks!!
Aug 17 2020 09:41 AM
So I tried to understand your problem but without success. I scanned code several times with a simple hand-held barcode scanner without any problems. It does not hang up anywhere and works idle.
The question that arises for me here is whether the problem could be with the scanner, which it does not follow and is causing problems with excel. It's just a thought, because I can't see any problem here.
If I may ask how and what is being scanned. What kind of QR coder do you use? does he have his own installation software? or is it recognized by Windows only with a driver?
Have you installed the latest drivers for your QR scanner?
Sorry for the question, but maybe the answers could help us.
Thx
Nikolino
I know I don't know anything (Socrates)