Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Progress bar in pure functions CHAR
  • Search across sheets in function ADDRESS
  • Expenses calendar, FaCal Basic Math
  • Filter. Google Sheets function Google Sheets
  • FORMULATEXT to show formulas FORMULATEXT
  • Sheet() and Sheets() Lookup and References
  • BMI Calculator Basic Math
  • Get monthly total from table with dates DATE

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

  • Blank (isempty) VS “” (null string) Excel User tips
  • Convert cell into textbox Excel User tips
  • Sheet() and Sheets() Lookup and References
  • WorksheetName and WorksheetsNo UDFs Lookup and References
  • Stale values (Scratched functions) Excel User tips
  • Excel @ before function names in formulas 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
  • Count Unique COUNTIF
  • MATCH fumction, just a simple search Lookup and References
  • Skills Grid Conditional Formatting
  • Compare2, a tool to compare two sheets using formulas Conditional Formatting
  • Excel Functions = XL f(x)s XLfxs
  • Formula Beautifier Excel User tips
  • CTRL+Y a mini macro Excel User tips
  • Calculate above and below me Average

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme