Comments for XLCubed Blog

Comment on Updating SQL Tables from Excel by Sven

Sven — Tue, 12 Jan 2021 14:17:30 +0000

Thank you for that information.
I can’t find the formula XL3RunArea but I can see XL3SqlArea. @XLCubed, maybe something for the next blog article.

Comment on Waterfall Charts in Excel – Time Analysis by Sven

Sven — Tue, 12 Jan 2021 13:58:11 +0000

Very cool – thank you!
Good examples with sample sheets are always very welcome! 😉

Comment on Heatmap Tables with Excel – Revisited by XLCubed

XLCubed — Fri, 08 Jan 2021 10:22:17 +0000

Hi Neil, which labels are you referring to? Please email support@xlcubed.com to let us know what you are trying to achieve. It has been a while since this post was written so there may be a better way to get the result you are after. Thanks!

Comment on Advanced Grid Reporting – MDX: by Richard Meijles

Richard Meijles — Tue, 01 Dec 2020 14:15:10 +0000

Hi XLCubed,

Interesting functionality!! I’ve used it a few times in a grid now.
When building a slicer, I see that the icon for a subcube is missing. Is it possible to add this in a slicer?

Thanks

Comment on Heatmap Tables with Excel – Revisited by Neil Dunay

Neil Dunay — Tue, 10 Nov 2020 14:59:32 +0000

How do you get the labels to appear? I don’t see that step.

Comment on Updating SQL Tables from Excel by Alexandre Bout (XlCubed Expert)

Alexandre Bout (XlCubed Expert) — Fri, 20 Mar 2020 18:07:42 +0000

Hi, very interesting article. there is nevertheless an even more powerful XL3RunArea function which is very poorly documented but which allows you to go much further in data management (update,insert records) with Sql Server. this function doesn’t validate line by line like XL3RunSQL but only one trigger allows you to validate all the records. it is therefore possible to update very large tables, which is not really appropriate with XL3RunSQL. in addition this function XL3RunArea works with the pager which allows to display a precise number of records on the screen while having the possibility to go forward or backward in the records of the table.

Comment on Custom Grid & Table Headers For Dynamic Sorting by Sven

Sven — Mon, 24 Feb 2020 09:25:08 +0000

Hi Catherine,

Thank you for that. It’s always good to see how things can be handled in different ways. We’ve implemented something similar – more complex as we have included an icon (character) to show the “active” column with sort direction and a second click on the column header changes the sort direction. You can imagine that this results in some “if” statements.

Comment on Number Formats by XLCubed

XLCubed — Mon, 18 Nov 2019 09:08:39 +0000

Hi Rob, if you go to Options > Workbook Options from the XLCubed ribbon, under the Formula Options tab you can set a value to replace null values with.

Comment on Number Formats by Rob Allison

Rob Allison — Thu, 07 Nov 2019 19:44:16 +0000

I am having trouble when XL3Lookup returns nothing from the cube. I would like it to return zero because the alternative just shows a blank cell and users are worried the formula did not work.

Comment on Using Grid Styles in XLCubed by XLCubed

XLCubed — Mon, 02 Sep 2019 08:03:55 +0000

Hi, this is not possible via the format sheet. If you would like any more help with formatting small multiples check out our help site or email us at support@xlcubed.com. Thanks!