User's PC is unstable
-
Maybe this has been asked before but are you on 32 bit excel and have you tried 64 bit? I know you said they were small files but I have had problems with the 32 bit version not being able to handle some spreadsheets.
-
Anytime I see "quirky" things like this I lean towards power and of all things RFI. Get a quality (not A Piece of Crap) online, or at minimum a line interactive UPS. Tripp-Lite Omni series used to be my go to for these issues. Ferrite wrap your cords in case there's any RFI possibly getting in (especially the Ethernet cable) from the AC unit.
-
Have you tried using Libre or Open Office? Yes, I realize it's not the same.. and yada yada... but meh - why not try.
What about if she is wireless? Does anyone else have issues with the spreadsheet?
What about on Ubuntu rather than WIn10?
-
It's been years ago, but the last time I dealt with excel issues. It was because of the Intel storage controller.
-
@black3dynamite said in User's PC is unstable:
It's been years ago, but the last time I dealt with excel issues. It was because of the Intel storage controller.
I hadn't heard that before. I'll have to keep that in mind.
-
@Dashrender said in User's PC is unstable:
Spinrite wouldn't report any issues
Sooooo that hasn't been updated in over 10 years. Also, who the hell is using magnetic drives for boot/applications?!?!
I'd expect office to pause/stutter, that's known behavior for running it from magnetic media.
-
@wrx7m said in User's PC is unstable:
There is a condenser for the IT AC unit right outside her office. I'm sure the power runs through the wall near where her computer sits. I moved the computer away from the outside wall a few years ago, requiring installing longer cables for monitors, keyboards, etc. Yet the problems continue, granted The computer only moved maybe 4 feet from that wall.
Move her to a streaming instance for excel (RemoteApp, Citrix, Horizon, 365 streaming app). see if it blows up when running on a server.
-
@StorageNinja said in User's PC is unstable:
@wrx7m said in User's PC is unstable:
There is a condenser for the IT AC unit right outside her office. I'm sure the power runs through the wall near where her computer sits. I moved the computer away from the outside wall a few years ago, requiring installing longer cables for monitors, keyboards, etc. Yet the problems continue, granted The computer only moved maybe 4 feet from that wall.
Move her to a streaming instance for excel (RemoteApp, Citrix, Horizon, 365 streaming app). see if it blows up when running on a server.
Like RemoteApp?
They'll need the licensing for it.
-
@Obsolesce said in User's PC is unstable:
Like RemoteApp?
They'll need the licensing for it.Streaming from O365 is bundled with a number of the licensing tiers (we have it, I use it to run the full version of Excel on my Mac). You also can run RDSH in trial mode for 90 days if memory serves.
Given it's been 10 years though, and the user (presumably has work to do in excel) having excel run somewhere else might just be a good way to move on to more important things even if it costs $100-200 (Unless Dash's time is free!)
-
Ive had one user who was having trouble with Excel like this and it was because she was using 32-bit office which was only using 4gb of memory even though her machine had 16gb memory. So excel was using all the memory it was allowed to but it was not enough and computer freaks out. She was using some large spreadsheets with powerbi. Anyway, moving her to the 64 bit versions fixed all her issues.
-
@StorageNinja said in User's PC is unstable:
@Obsolesce said in User's PC is unstable:
Like RemoteApp?
They'll need the licensing for it.Streaming from O365 is bundled with a number of the licensing tiers (we have it, I use it to run the full version of Excel on my Mac). You also can run RDSH in trial mode for 90 days if memory serves.
Given it's been 10 years though, and the user (presumably has work to do in excel) having excel run somewhere else might just be a good way to move on to more important things even if it costs $100-200 (Unless Dash's time is free!)
I was talking about RemoteApp, which requires RDS.
-
Oh, the many times I got called the cause of Excel...
I have felt after my encounter with it, is sometimes a specific version is better than the latest, and sometimes an update won't work as a fresh install with the update, and it all depends on Visual C++ runtimes and dot net framework.
That said, nothing helps it more than fresh Windows Install + latest .net + latest C++ and good stable version of it. Also use the 32-bit , and disable addons and macros
-
@Emad-R said in User's PC is unstable:
That said, nothing helps it more than fresh Windows Install + latest .net + latest C++ and good stable version of it. Also use the 32-bit , and disable addons and macros
He's done at least most of that already, more than once, I believe.
-
@wirestyle22 said in User's PC is unstable:
@Dashrender said in User's PC is unstable:
@scottalanmiller said in User's PC is unstable:
Common factors are: user and Excel.
Assuming other users use Excel for the same spreadsheets without issues, common factor is just the user.
no, the Excel sheets are unique to her. Sadly.
I'd love to blame the user, but I just don't see her doing anything unusual. In fact, from a general perspective, she's one of the least likely people to be doing weird/bad things on her computer.
I'd still test it with a Mandatory roaming profile
Why do you think a mandatory roaming profile would make any difference? I'm curious the thought process here?
She has no roaming profile at all. She saves 90%+ of her stuff to her redirected Documents folder. Documents and Favorites(IE) are the only redirected folders - While directing the desktop can work, I've seen some issues with it and try to avoid it when possible.
-
@CCWTech said in User's PC is unstable:
Maybe this has been asked before but are you on 32 bit excel and have you tried 64 bit? I know you said they were small files but I have had problems with the 32 bit version not being able to handle some spreadsheets.
Re-installing Office is on the agenda when she allows me access to her machine.. I could easily move to 64 Bit at that time.
I had been deploying 32 bit until about a month ago. I read that MS is moving away from 32 bit, so I figured now was a good time to change my base image to 64 bit Office.
-
@jt1001001 said in User's PC is unstable:
Anytime I see "quirky" things like this I lean towards power and of all things RFI. Get a quality (not A Piece of Crap) online, or at minimum a line interactive UPS. Tripp-Lite Omni series used to be my go to for these issues. Ferrite wrap your cords in case there's any RFI possibly getting in (especially the Ethernet cable) from the AC unit.
She has a Eaton 5S 700 USP. I'd don't have any Ferrite wrapped cords - I'll have to see what I can get.
-
@Dashrender said in User's PC is unstable:
@wirestyle22 said in User's PC is unstable:
@Dashrender said in User's PC is unstable:
@scottalanmiller said in User's PC is unstable:
Common factors are: user and Excel.
Assuming other users use Excel for the same spreadsheets without issues, common factor is just the user.
no, the Excel sheets are unique to her. Sadly.
I'd love to blame the user, but I just don't see her doing anything unusual. In fact, from a general perspective, she's one of the least likely people to be doing weird/bad things on her computer.
I'd still test it with a Mandatory roaming profile
Why do you think a mandatory roaming profile would make any difference? I'm curious the thought process here?
She has no roaming profile at all. She saves 90%+ of her stuff to her redirected Documents folder. Documents and Favorites(IE) are the only redirected folders - While directing the desktop can work, I've seen some issues with it and try to avoid it when possible.
Because it's a pre-configured profile. It would prevent her from being able to make any permanent changes to her profile. If it is a case of the user doing something wrong this would be a good way of finding out.
-
@gjacobse said in User's PC is unstable:
Have you tried using Libre or Open Office? Yes, I realize it's not the same.. and yada yada... but meh - why not try.
What about if she is wireless? Does anyone else have issues with the spreadsheet?
What about on Ubuntu rather than WIn10?
LOL - no chance in hell the user will give a different application a try.
She was wireless at one point on this machine - in my attempt to remove the NIC/cabling from the equation, things were not any more stable.
She shares very few spreadsheets with other people, those that she does, there are no reported issues (in general). I'll make a dedicated post about a singular issue we had last week.
OMG - ROFLOL - seriously - give Ubuntu to a user - man, that's rich... likely will never happen around here - I was in a meeting 3 weeks ago where I requested that use use Linux for a server project for our HVAC systems, and was told - NOPE you can't use that because there would be no one to support it if you died. I sighed and moved on.
-
Last week a user had exported a XLS from an application which was then opened in Excel 2016. The application that created the XLS form and somehow locked a column to a non-numerical data type that we were unable to change, even using right click > format cells > Number tab > Number.
The form was emailed to my boss, who saved it as an XLSX file, and upon opening that file, my boss saw little green triangles in the upper left hand corners of this entire column. Clicking on the green triangle allowed my boss to see an error message with an option to change the data type - totally weird, but it allowed her to change the data type, and then do a summation on the whole column.
The original user (OU) did not see these green triangles. Eventually I found that the OU did not have the Error Checking option enabled (File > Option > Formulas > Error Checking > Enable background error checking). Upon enabling this, the OU did have the green triangles and was able to modify the column data type.
This is the only reported Excel related issue between my boss and another user in more than 5 years.
-
@black3dynamite said in User's PC is unstable:
It's been years ago, but the last time I dealt with excel issues. It was because of the Intel storage controller.
Really? What was the solution?
