Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • FORMULATEXT to show formulas FORMULATEXT
  • Return 12 values in one number AND
  • Middle name + 1st name Basic Math
  • Show developer tab Excel User tips
  • Sum of divide – Array formula Array formula
  • Count how many times letter found Formulas - combined functions
  • LastSunday, LastSaturday Date and Time
  • UDF – Convert Number into text (English and Arabic) User-Defined f(x)s = UDF

Recover the unrecoverable

Posted on January 23, 2019 By ANmar

Working a lot with Excel means seeing lots of errors and bugs inside Excel

Some of those are not likely bugs, but more like reaching the limit of the application.

So, the other day, after getting upset with Excel keep crashing and makes me lose my changes, I investigate it and found where does Excel save unsaved spreadsheets.

Those Excel failed to report in its own “Recoverable spreadsheets”.

Buy not for me, here is the location where Excel actually save those.

Hope this helps.

 

Excel User tips, Worksheet Tags:recover, restore, temp

Post navigation

Previous Post: Fixed length ID
Next Post: Shades of gray

Related Posts

  • Paste Special Percentage Excel User tips
  • Excel sessions – 2013 VS 2010 Excel User tips
  • When Excel functions are not enough Excel User tips
  • Shapes with dynamic output Excel User tips
  • Formula Beautifier Excel User tips
  • Excel @ before function names in formulas Excel User tips

Recent Posts

  • Stale values (Scratched functions)
  • Middle name + 1st name
  • LastSunday, LastSaturday
  • Paste Special Percentage
  • Jan8 date format

Archives

Categories

  • Array formula (1)
  • Formulas – combined functions (58)
  • Google Sheets (2)
  • Non-functions (36)
    • ActiveX controls (2)
    • Conditional Formatting (7)
    • Data Validation (7)
    • Excel User tips (19)
    • Format Cells (6)
    • Graphics (4)
    • Names (3)
  • Standard functions (82)
    • Basic Math (18)
    • Date and Time (16)
      • DATE (9)
      • Hour (1)
      • MONTH (7)
      • NETWORKDAYS (2)
      • TODAY (7)
      • WEEKDAY (8)
      • WEEKNUM (1)
      • YEAR (8)
    • Engineering (1)
      • CONVERT (1)
    • Information (6)
      • CELL (4)
      • ISERROR (1)
      • N (1)
    • Logical (30)
      • AND (5)
      • IF (24)
      • IFERROR (6)
      • IFNA (1)
      • IFS (1)
      • ISERROR (1)
      • OR (2)
    • Lookup and References (36)
      • ADDRESS (4)
      • CHOOSE (3)
      • COLUMN (7)
      • FORMULATEXT (1)
      • HLOOKUP (1)
      • HYPERLINK (2)
      • INDEX (5)
      • INDIRECT (6)
      • MATCH (12)
      • OFFSET (15)
      • ROW (11)
      • VLOOKUP (5)
    • Math and Trig (24)
      • ABS (1)
      • CEILING (1)
      • COUNT (1)
      • COUNTA (4)
      • INT (9)
      • LARGE (2)
      • MAX (1)
      • Min (2)
      • SMALL (3)
      • SUM (3)
      • SUMIF (1)
      • SUMIFS (2)
      • SUMPRODUCT (1)
    • Statistical (5)
      • COUNTIF (4)
      • COUNTIFS (1)
    • Texts and Strings (24)
      • CHAR (5)
      • CONCATINATE (1)
      • FIND (1)
      • LEFT (8)
      • Len (4)
      • MID (9)
      • REPT (3)
      • RIGHT (2)
      • SEARCH (9)
      • STRING (1)
      • SUBSTITUTE (2)
      • TEXT (4)
      • TRIM (2)
      • VALUE (2)
  • Uncategorized (2)
  • User-Defined f(x)s = UDF (3)
    • HyperlinkOf (1)
  • Worksheet (16)
  • XLfxs (2)

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
  • Excel sessions – 2013 VS 2010 Excel User tips
  • Formula Beautifier Excel User tips
  • Excel @ before function names in formulas Excel User tips
  • Multiple lines in cell using functions CHAR
  • Extract Address into table Formulas - combined functions
  • New function IFERROR, finally IFERROR
  • IF with AND and IF with OR AND
  • Middle name + 1st name Basic Math

Copyright © 2025 Excel Functions.

Powered by PressBook News Dark theme