Initialising Styles and Formats for live data pulls

This article explains how to set up cell colours and styles before entering an ipullDisplay function.

ipullDisplay only pulls back a page's values, not its colours and styles. The quickest way to set up the styles is to do a manual pull into the range before entering the ipullDisplay.

 

1 Enter your ipull function

 

 

2 Name the Pulling Range

Giving your pulling range a name helps you to easily select it again. To do this, select the range of cells you want to pull into, then enter a name into the name box in the top left:

Whenever you need to highlight this range again, just select the name from the name box dropdown and all the cells in the range will be selected.

 

3 Manually Pull the Styles and Formats

With the target range highlighted, choose Pull from the ipushpull ribbon:

 

Choose the page you are pulling from:

 

And press the Pull button. This will pull a snapshot of the page into your range, with all its formats, colours, column widths etc.:

 

4 Enter the ipullDisplay

Finally, with the entire range still selected, enter your ipullDisplay function (as described here) and hit CTRL+SHIFT+ENTER:

The styles and formats will be left unchanged, but the values will now update live.

Was this article helpful?
0 out of 0 found this helpful
Powered by Zendesk