Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Looplist – Repeating months using formulas Basic Math
  • Formula Beautifier Excel User tips
  • FORMULATEXT to show formulas FORMULATEXT
  • Cells with additional spaces AND
  • Recover the unrecoverable Excel User tips
  • Comments versus Notes Excel User tips
  • Unix DateTime Number Basic Math
  • Searching table in 2 dimensions. Formulas - combined functions

Excel sessions – 2013 VS 2010

Posted on June 9, 2017 By ANmar

Excel 2010 was great because you can easily open another Excel session while your current session is working.

This allowed us to run multiple tools at the same time, since those two sessions are separated and do not touch.

However, starting Excel  2013, the interface changed, making it harder to run new session or open Excel while we have another Excel session running some long process.

that is when we start to look around and found a solution

you can FORCE Excel to open another separated session by running command line in run

Excel -X

This way, you can have two separated Excel sessions that do not affect each other, and we can now run several instances of our long macros.

 

 

Excel User tips, Non-functions Tags:Excel2010, Excel2013, Non-Functions

Post navigation

Previous Post: Count how many times letter found
Next Post: OFFSET+MATCH

Related Posts

  • CTRL+Y a mini macro Excel User tips
  • Scorring, saving multiple outputs in 1 number Basic Math
  • Convert cell into textbox Excel User tips
  • Recover the unrecoverable Excel User tips
  • Excel ad from early 90s Non-functions
  • When Excel functions are not enough 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
  • Stale values (Scratched functions) Excel User tips
  • OFFSET+MATCH Formulas - combined functions
  • When Excel functions are not enough Excel User tips
  • Edit directly in cell Excel User tips
  • Excel Dynamic Drop-Downs that grow with you COUNTA
  • Middle name + 1st name Basic Math
  • LastSunday, LastSaturday Date and Time
  • Convert cell into textbox Excel User tips

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme