Sep 25 2020 05:58 AM
Sep 25 2020 05:58 AM
When I try to format a cell in Excel - bolding, underlining, switching font size - the program freezes and I need to re-start. Is a new issue from last 2 days having worked without problems previously.
I've tried program repair, updates and re-installing Office and running in safe mode. No luck. Any suggestions for how I solve?
May 05 2022 12:34 PM
Jun 17 2022 01:23 AM
@Emiru that is amazing. I have encountered this problem with excel since the beginning of time. I always imagined it was a memory problem, yet it never seemed to go away even with new laptop, upgraded memory, etc. This wizardry of changing default printer to PDF actually seems to have stopped the occurrence of freezes. There's another of my pet hates ticked off! Many thanks.
Jul 14 2022 07:41 AM
Sep 15 2022 08:50 AM
Oct 01 2022 08:13 AM - edited Oct 01 2022 08:43 AM
I have a similar issue - Excel crashing when trying to format or print. It also crashes when I copy/paste from Word, websites, or any other source except another Excel file or Notepad. Word crashes too, but only if I try to print. This has been going on for two months, and after trying everything under the sun, I gave up and have just been working around the bug.
I found this thread today and tried restarting the spooler service and setting the default printer as PDF (I had to do it in Windows settings, since Excel crashed as soon as I clicked the Print options). Sadly, it has not solved the problem for me
EDIT: Since posting the above, I tried stopping the printer spooler, and BINGO! Excel was working again! I could format and copy/paste - yay! Sadly, the spooler restarts whenever I restart the computer, even after I set start-up to "Disabled" in Services. It's still a band-aid and not a cure. It means I have to stop the spooler every time I want to use Excel, and then I can't print. I'd love to know why this is happening, and if there's a way to fix it.
Oct 07 2022 01:01 AM
@Emiru thank you for your solution! I experienced this bug when using Excel interop from C# code -- my code would periodically freeze at a line which programmatically set a font to bold. But I'm now certain it's the same underlying problem, and changing my Windows default printer fixed it. I've written up a corresponding question and answer at https://stackoverflow.com/q/73984079/1688738.
May 04 2023 11:31 PM