Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • CTRL+Y a mini macro Excel User tips
  • Insert Blank rows into table using functions CHAR
  • GoLast to jump to last cell in a column CELL
  • Convert 2-column into wide (column-row) table Formulas - combined functions
  • Validation based on another Validation COUNTA
  • Workdays – Across months DATE
  • Return 12 values in one number AND
  • Multiple lines in cell using functions CHAR

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
  • The Excel “&” bug Excel User tips
  • Edit directly in cell Excel User tips
  • Sheet() and Sheets() Lookup and References
  • Comments versus Notes Excel User tips
  • Excel keeps converting all cells to “Date” (or Time) 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
  • Return 12 values in one number AND
  • Hello world! Uncategorized
  • The Excel “&” bug Excel User tips
  • MID + SEARCH to convert cell to rows MID
  • When Excel tells you to go get some life Excel User tips
  • CTRL+Y a mini macro Excel User tips
  • Text-to-Columns, dynamically using formulas IFERROR
  • State Abbr with Index+Match+Validation Data Validation

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme