Comments on: How’d you like that….displayed! ../../../../2018/10/howd-you-like-that-displayed/ XLCubed Blog Wed, 20 Feb 2019 14:00:14 +0000 hourly 1 https://wordpress.org/?v=5.3.21 By: XLCubed ../../../../2018/10/howd-you-like-that-displayed/#comment-29654 Mon, 04 Feb 2019 09:24:38 +0000 https://blog.xlcubed.com/?p=4506#comment-29654 Hi Christian,

That part of the article is describing a ripple effect to force the grid to refresh: the slicer activates an XL3Link, which updates a cell to TRUE, which triggers an XL3RefreshSheetObjects formula.

You can insert an XL3Link from the XLCubed ribbon > Insert formula > XL3Link. In this scenario, you could leave the “Link to” field blank (we don’t need to jump to a new location in the workbook). The important part is setting the target cell with the value TRUE. You will then need to create an XL3RefreshObjects formula in another cell. This formula needs a ‘trigger’, i.e. something to tell it when to refresh. In this example it is the cell $I$6. So, when the XL3Link it clicked (or activated via the slicer), this sets I6 to true, which tells the XL3RefreshObjects to run. It does this, then sets I6 back to false.

If you need more details or a working example of this, please contact support@xlcubed.com.

]]>
By: Christian ../../../../2018/10/howd-you-like-that-displayed/#comment-29618 Fri, 01 Feb 2019 11:02:28 +0000 https://blog.xlcubed.com/?p=4506#comment-29618 I’d love to use this feature. But I don’t get what you’re doing with cells I6 and so forth. Could you post the a picture of the complete excel range used? In the beginning your explanation is marvellous, but later I’m just getting confused.

]]>