Dave The Web Guy

Remember Hyperlinks?
Comments

Go Back

Actual Data Analyst Spells Out Common Excel Support Challenge

08/11/2021

I sometimes get called up to fix issues with Excel running too slow or throwing cryptic error messages that not only confound my local user base, but, in checking, the entire Googlesphere of users which never arrives at a consistent definite resolution.  The rate of resolving these issues by simply manhandling the local PC or instance of MS Office is something like zero percent.

If an Excel instance is generally running fine, as is the OS as a whole, more often than not I wind up with the sense that whatever is being "Excel-processed" probably shouldn't be, or, if ever should have been and was, is beginning to reach its implied level of non-suitability for the task.   It's either beginning to work with a dataset that is increasingly too large for stability, or there has been an increase in the inter-dependencies of the specific worksheet as a whole -- usually both.  The issues sometimes affect just one user, a small subset, or everyone using the same "data solution" called Excel.

It's not my place to play role of "data analyst" in these situations, but, just in knowing how these things work over 20 or so years, my guess is always that an "Excel-centered solution" that at a lower scale was just fine, is being applied without check or re-analysis, as the larger scale use case begins to unfold.

Direct link to video if it doesn't play right here, is here instead.



  By Dave for Personal Blog.

Comments (0) | Promote (0) | PermShare | Focuses (1538)

Register to Comment

Go Back

Share

Comments

Sort by Promotion Score

There are no comments. Be the first to make one!

You must be logged in to comment. You can register here.

Go Back

Participate
My Blabbity Blabs
Facebook Logo Twitter Logo LinkedIn Logo RSS Logo Reddit Logo Disqus Logo You Tube Logo
Live Webcam
Twitter Feed
Other REAL Blogs (Buffalo)

Discovering Buffalo One Street at a Time

Categories

<