Excel: A Simple Manual Pull
A Manual Pull is the simplest way to import ipushpull content into your Excel spreadsheets. Pages are pulled into your workbook 'on-demand', meaning you stay in control and decide exactly when you want to update them. All it takes is a few mouse-clicks and no formulas are required. This post will show you easy it is.
Before you can pull any content, you should log in to ipushpull.
1. Highlight the range of cells where you would like the ipushpull page to be pulled to.
2. On the ipushpull ribbon, choose Pull to choose the page you want to pull content from.
3. Choose the ipushpull page you want to pull the content from and click the Pull button at the bottom of the dialog.
Tip: If you have a lot of ipushpull pages, you can filter the list using the filter box at the top of the dialog.
Tip: To view the content before you pull it into Excel, you can double-click a page to open it your browser.
That's all there is to it. The page you selected will appear in the highlighted range and you can use the content just as you would any other cells in Excel.
Any Questions?
Will the pulled page be saved with my workbook?
Yes. Save your workbook in the usual way and the ipushpull content will be saved too. It will always be there, even when you are not logged in to ipushpull.
What can I do with a page pulled into my Excel spreadsheet?
Anything you can do with any other cells in your spreadsheet. You can cut and paste, drag and drop, use the data in formulas and as the source for an Excel chart, to name a few.
The page has been updated by a colleague. How do I update it in my spreadsheet?
Simply repeat steps 1 - 3 above to get the latest version of the page. All your formulas and charts will automatically update to reflect the new values.
I'm not sure how big the page I'm pulling is. What is the best way to do it?
When choosing the page, simply select the Pull to New Worksheet option.
This will create a new worksheet in your Excel workbook and pull the full size page into it. From there you can see how big it is and paste it into an appropriate range elsewhere in your workbook (or a different workbook).