Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Commenting a block of code in VBA
- Arrays vs Collections vs Dictionary Objects (and Dictionary help)
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Cubic Splines
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Using Goal Seek on Multiple Cells
- Fitting high order polynomials
- Beam actions and deflections by Macaulay's Method
- Using LINEST for non-linear curve fitting
Recent Comments
Tag Archives: Office 365
Getting Excel Solver working
Recently I found that for unknown reasons the Excel Solver add-in was not working. Opening the add-ins list from the Devloper tab showed that it had become deactivated (also accessible from File-Options-Add-ins): Clicking the Solver check box returned a message … Continue reading
Posted in Computing - general, Excel
Tagged Excel, Office 365, Solver add-in, Solver disabled
Leave a comment
Smart Indenter and Excel 2013
I have recently installed Office 365 on a new computer running Windows 8.1 (actually the third one in just over a month, but that’s another story). Office 2013 has several annoying features, but for me the most annoying was that … Continue reading
Posted in Computing - general, Excel, VBA
Tagged 64 bit Office, Code indenter, Excel, Office 365, VBA, Windows 8.1
26 Comments