Excel freezing

Emad R

Excel is a bitch

+200

Emad R

EXCEL IS THE DEVIL

dude i supported 3 ladies that uses excel alot like receptionest in hosptial, the only real fix. and they knew excel is soo bad that they didnt really expect from me any solutions. I would just listen to them on how they have to repeat the data entry part ... try to have candy with you when you support such cases

take the data

create new excel file

paste that date, no format, or reduce formatting as much as possible.

Excel is stupid in optimizing, sometimes a user which is valid tries to do quick thing and what he does is
make like infinite number of pink column , so excel keeps saving that. you need to start fresh with values only

And XLSB is fast, try that but take backups

notverypunny

@Dashrender said in Excel freezing:

So the ongoing saga that is this user.

This morning - the PC had been up for 4 days (which really shouldn't be an issue) when using Excel - sheets were left open over the weekend for sure! - the search function on the open screen would not allow them to click into the search box. It just sat there dumb... you could close it, but nothing else. When you clicked, literally nothing happened.

Rebooting 'fixed' the issue.

The computer has 16 GB RAM and 256 GB NMVe SSD.

Pending install for updates?

wrx7m

@notverypunny said in Excel freezing:

Excel... check the specific spreadsheet(s) workbook(s) that they're having problems with.... we've had a few cases where people are causing problems with data references and other wonderful things that they find when googling for a solution. Like statically referencing another file on their desktop or personal share and then sending the file to someone else only to find that it doesn't work for the other person.

Had issues where someone added some vbs and it caused the file to crash.

wrx7m

@Emad-R said in Excel freezing:

take the data
create new excel file
paste that date, no format, or reduce formatting as much as possible.

I have also had people do this to fix weird issues. It has fixed some.

wrx7m

@VoIP_n00b said in Excel freezing:

Excel is a bitch

Especially, here. They are running all their forecasts through it. Excel using something like 16GB of RAM for one sheet.

Dashrender

@notverypunny said in Excel freezing:

d for sure! - the search function on the open screen would not allow them to click into the search box. It just sat there dumb... you could close

Not that I am aware of - I'd have to check the dates on any updates installed.

Dashrender

@wrx7m said in Excel freezing:

@Emad-R said in Excel freezing:

take the data
create new excel file
paste that date, no format, or reduce formatting as much as possible.

I have also had people do this to fix weird issues. It has fixed some.

yeah, some of these files are 30 years old.

Dashrender

@wrx7m said in Excel freezing:

@VoIP_n00b said in Excel freezing:

Excel is a bitch

Especially, here. They are running all their forecasts through it. Excel using something like 16GB of RAM for one sheet.

As much as that likely belongs on a DB server somewhere - who's going to set it up? and program the new interface, etc?

scotth

@Dashrender said in Excel freezing:

@wrx7m said in Excel freezing:

@Emad-R said in Excel freezing:

take the data
create new excel file
paste that date, no format, or reduce formatting as much as possible.

I have also had people do this to fix weird issues. It has fixed some.

yeah, some of these files are 30 years old.

30 years old. Sheeez. Those could have originated on Lotus. Copy / past like previously suggested might do some good.

travisdh1

@Dashrender said in Excel freezing:

@wrx7m said in Excel freezing:

@VoIP_n00b said in Excel freezing:

Excel is a bitch

Especially, here. They are running all their forecasts through it. Excel using something like 16GB of RAM for one sheet.

As much as that likely belongs on a DB server somewhere - who's going to set it up? and program the new interface, etc?

Ever use Microsoft Dynamics? Uses a backend database with Excel as the front end. Most horrendous mishmash I've ever seen. That was the 2005 version, so hopefully outdated by now.

wrx7m

@Dashrender said in Excel freezing:

@wrx7m said in Excel freezing:

@VoIP_n00b said in Excel freezing:

Excel is a bitch

Especially, here. They are running all their forecasts through it. Excel using something like 16GB of RAM for one sheet.

As much as that likely belongs on a DB server somewhere - who's going to set it up? and program the new interface, etc?

yeah. that has been in the works for over a year. We are syncing the data to SQL and then will be able to run queries and also export it to Domo.