formulae – XLCubed Blog ../../../ XLCubed Blog Thu, 16 Jun 2022 08:44:44 +0000 en-GB hourly 1 https://wordpress.org/?v=5.3.21 ../../../wp-content/uploads/2016/09/cropped-logo_512_512-150x150.png formulae – XLCubed Blog ../../../ 32 32 Updating SQL Tables from Excel ../../../2020/03/updating-sql-tables-from-excel/ ../../../2020/03/updating-sql-tables-from-excel/#comments Thu, 05 Mar 2020 15:55:02 +0000 https://blog.xlcubed.com/?p=5896 Most of our customers use XLCubed for reporting, analysis and data visualisation, but an increasing number use it for data updates, either within budgeting and forecasting solutions or in niche applications. XL3RunSQL is a neat method for running SQL updates from Excel, and allows users to build input forms (which can ultimately be web-enabled) quickly […]

The post Updating SQL Tables from Excel appeared first on XLCubed Blog.

]]> ../../../2020/03/updating-sql-tables-from-excel/feed/ 2 Warning: Excel Can Get Volatile (revised) ../../../2019/10/warning-excel-can-get-volatile-revised/ ../../../2019/10/warning-excel-can-get-volatile-revised/#respond Fri, 04 Oct 2019 12:01:15 +0000 https://blog.xlcubed.com/?p=5810 This is a revised version of this post: Warning: Excel can get Volatile Excel is a great tool for dashboard/report delivery and design (it’s why we created our addin in the first place!), but there is a hidden performance trap: Offset, Now, Today, Cell, Indirect, Info and Rand If you’ve ever used any of these […]

The post Warning: Excel Can Get Volatile (revised) appeared first on XLCubed Blog.

]]> ../../../2019/10/warning-excel-can-get-volatile-revised/feed/ 0