What is the most frustrating thing about excel?

ashakantasharma

Board Regular
Joined
May 28, 2020
Messages
81
Office Version
365, 2019
Platform
Windows, Mobile, Web
Excel seems to give you a two-second window at the start of a full workbook calculation cycle to instruct it to abort. If you miss that window, any further attempts to abort cause Excel to lock-up and white-out, and then you're stuck waiting for it to finish the full calculation cycle. This can be especially frustrating if you happen to have multiple workbooks open when Excel suddenly decides to auto-save and recalculate all formulas across all workbooks. It's even more frustrating if any of those open workbooks have calculation-intensive sensitivity tables or self-referencing cells. I've had to manually terminate Excel more times than I can count when this issue has cropped up in the middle of a time-sensitive analysis.

Incorrect reading of a date in dd/mm/yyyy format and then inability to change it through just one click: I had a csv file which had all dates in dd/mm/yyyy format, but when I copied it into excel, it read dates like the 1/12/2001 as 12-Jan-2001 and left dates like 14/5/2001 as is. Frustratingly, there is no one click solution to correct this, and I had to write long formulas to make excel read all the dates correctly.
 

Some videos you may like

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

B___P

Active Member
Joined
Oct 31, 2015
Messages
419
@ashakantasharma to import date I use this
cells(r,c).formulalocal=yourvalue
This way I let excel to translate from USA standard

I have a background in economics and I hate not to use directly Financial formulas in excel.
When you calculate a monthly installment at a interest rate of 10%, excel uses 10%/12 and not
(1+0,10)^(1/12)-1 as the monthly interest rate. I hate to use extra cells to calculate input values.
 

JonXL

Active Member
Joined
Feb 5, 2018
Messages
343
Office Version
365, 2016
Platform
Windows
Mark Ziemann, Yotam Eren, and Assam El-Osta
Gene name errors are widespread in the scientific literature
Gene name errors are widespread in the scientific literature
Interesting to see a study backing what many of us already knew: the way Excel handles things that look like numbers is a problem indeed.

I've never had the need to enter a 15-digit number as a number - ever. The application needs some place to adjust defaults on this so I can specify business-specific settings on what is and what isn't to be treated as a number automatically.
 

MARK858

MrExcel MVP
Joined
Nov 12, 2010
Messages
12,880
Office Version
365, 2010
Platform
Windows, Mobile
Frustratingly, there is no one click solution to correct this, and I had to write long formulas to make excel read all the dates correctly.
You can do it using the date settings in Text to Columns.
 

limfoo

New Member
Joined
Aug 7, 2020
Messages
0
Office Version
365
Platform
Windows
Sometimes cell formats automatically default to "date" instead of "general."
 

Watch MrExcel Video

Forum statistics

Threads
1,102,241
Messages
5,485,597
Members
407,504
Latest member
inexperiencedOne

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top