Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Cubic Splines
- Using LINEST for non-linear curve fitting
- Latex Maths Text in Excel
- Deflections and Moments in Rectangular Plates
- Downloads by category
- Fitting high order polynomials
- Retrieving unique values from a range or array ...
- Using conditional formatting with array formulas
- P-Y Curve function
Recent Comments
Category Archives: Computing – general
Indexing pdf files – update
My Windows search function recently once again stopped indexing pdf files, probably associated with an upgrade to Windows 11. Previously this was fixed by downloading the file PDFFilter64Setup.msi from the Adobe site, but that download no longer works, and there … Continue reading
Downloads update
A list of files available for free download can be found under the Downloads link at the top of the page: The list has now been updated and there are now 189 files available for download, most with open source … Continue reading
Posted in Computing - general, Excel
Tagged Download list, Files for download, open source code, Python, PyXLL, VBA, xlwings
Leave a comment
Microsoft blocking VBA in downloaded files (or do they?)
Microsoft announced earlier this year that they would be automatically blocking macros in downloaded Office files (as a security measure), then recently they said they wouldn’t, then yesterday they said they would, but not right now. For more details, plus … Continue reading
Posted in Computing - general, Excel, UDFs, VBA
Tagged download security, Security certificate, VBA macro block
1 Comment
Removing Add-ins
Recently I had problems with an Excel Add-in that was still trying to run, and generating error messages, even after being removed from the add-in list and uninstalled. After much searching and trying suggested methods that didn’t work, I finally … Continue reading
Posted in Computing - general, Excel, Link to dll, Link to Python, VBA
Tagged Add-in problems, Excel, Link to Python, Regedit, Remove add-ins, VBA, Windows registry
Leave a comment
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