Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Dynamic selection list ActiveX controls
  • Excel Dynamic Drop-Downs that grow with you COUNTA
  • CountIf limitation COUNTIF
  • Excel @ before function names in formulas Excel User tips
  • Excel keeps converting all cells to “Date” (or Time) Excel User tips
  • Filter. Google Sheets function Google Sheets
  • Cuts string of list of items Formulas - combined functions
  • FORMULATEXT to show formulas FORMULATEXT

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

  • Excel @ before function names in formulas Excel User tips
  • Spreadsheet Compare application Excel User tips
  • Excel keeps converting all cells to “Date” (or Time) Excel User tips
  • Convert cell into textbox Excel User tips
  • Stale values (Scratched functions) Excel User tips
  • Paste Special Percentage 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
  • 6174 Kaprekar’s constant Basic Math
  • Get 3rd Wednesday of month Basic Math
  • Looplist – Repeating months using formulas Basic Math
  • Excel sessions – 2013 VS 2010 Excel User tips
  • State Abbr with Index+Match+Validation Data Validation
  • When Excel functions are not enough Excel User tips
  • Always get 1st name (or last) Formulas - combined functions
  • Excel Dynamic Drop-Downs that grow with you COUNTA

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme