Search
-
Recent Posts
- Manual Calculation No Longer Viral!
- Only Calculating the Active Workbook
- Excel Screen-updating Performance Comparison.
- Short-circuiting in Array Formulas
- Short-circuiting Excel Formulas: IF, CHOOSE, IFS and SWITCH
- Finding VBA Bottlenecks with VBA Profiler
- Excel Virtually Global
- FastExcel Version 4 – with Introductory Offer
- Backward Compatibility of Office 365 Dynamic Arrays (Updated 23 Sep 2020)
- Excel Summit South 2019
Recent Comments
Post Archive
- March 2023 (2)
- January 2023 (3)
- October 2020 (1)
- July 2020 (1)
- February 2020 (1)
- May 2019 (2)
- January 2019 (1)
- July 2018 (2)
- January 2018 (1)
- September 2017 (1)
- April 2017 (2)
- March 2017 (4)
- February 2017 (1)
- December 2016 (1)
- November 2016 (3)
- October 2016 (2)
- July 2016 (1)
- April 2016 (1)
- February 2016 (1)
- December 2015 (4)
- November 2015 (2)
- September 2015 (2)
- May 2015 (2)
- February 2015 (1)
- January 2015 (2)
- December 2014 (1)
- November 2014 (2)
- October 2014 (3)
- September 2014 (2)
- August 2014 (2)
- June 2014 (1)
- April 2014 (1)
- February 2014 (1)
- January 2014 (3)
- December 2013 (2)
- November 2013 (4)
- October 2013 (6)
- September 2013 (4)
- February 2013 (3)
- January 2013 (3)
- December 2012 (4)
- November 2012 (2)
- October 2012 (2)
- September 2012 (1)
- July 2012 (6)
- June 2012 (7)
- April 2012 (1)
- March 2012 (2)
- February 2012 (1)
- January 2012 (3)
- December 2011 (1)
- November 2011 (3)
- October 2011 (2)
- September 2011 (2)
- August 2011 (1)
- July 2011 (4)
- June 2011 (8)
- May 2011 (4)
Categories
Blogroll
RSS
Blog Stats
- 1,289,362 hits
- Follow Excel and UDF Performance Stuff on WordPress.com
Monthly Archives: December 2013
Excel 2013 SDI Bug: “Calculate” in Status Bar strikes again
In the old days (I’m talking Excel 5 to Excel 2003 here) there was a worrying situation you could find yourself in where, no matter what you did, Excel would show you “Calculate” in the statusbar. Even when actually nothing … Continue reading
Posted in Calculation, VBA
12 Comments
Finding out if a function is Volatile or Multithreaded using VBA: UDFs for UDFs
Part of my new Profiling Formulas and Functions command requires the code to determine whether a Function isĀ a native built-in Excel function, or an XLL function, or some other kind (VBA, Automation). And I also want to know if … Continue reading
Posted in Calculation, UDF, VBA, XLL
Leave a comment