Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Convert 2-column into wide (column-row) table Formulas - combined functions
  • Search across sheets in function ADDRESS
  • LastSunday, LastSaturday Date and Time
  • VALUE() of LEFT() Formulas - combined functions
  • 0% interest promotion Basic Math
  • Expenses calendar, FaCal Basic Math
  • Workdays – Across months DATE
  • CONVERT function CONVERT

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

  • WorksheetName and WorksheetsNo UDFs Lookup and References
  • Blank (isempty) VS “” (null string) Excel User tips
  • Excel sessions – 2013 VS 2010 Excel User tips
  • Shapes with dynamic output Excel User tips
  • Formula Beautifier Excel User tips
  • Excel keeps converting all cells to “Date” (or Time) Excel User tips

Recent Posts

  • Calculate above and below me
  • Stale values (Scratched functions)
  • Middle name + 1st name
  • LastSunday, LastSaturday
  • Paste Special Percentage

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 (83)
    • 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 (31)
      • AND (5)
      • IF (25)
      • IFERROR (7)
      • 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 (6)
      • Average (1)
      • 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
  • Repeated Offset Basic Math
  • Cells with additional spaces AND
  • Filter. Google Sheets function Google Sheets
  • IFS (and IFNA) to avoid nested IFs Formulas - combined functions
  • Sum of divide – Array formula Array formula
  • Edit directly in cell Excel User tips
  • Paste Special Percentage Excel User tips
  • Min Max vehicle Formulas - combined functions

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme