Managing Favourites

What would you like to do?

• Create a grid report which I want to save as a favourite for my own use

1. Create grid report and in Report Designer click Favourites icon highlighted
2. You will be prompted to enter a name and then OK.

1. This will add the report to your Favourites.
2. Click Favourites icon in XLCubed Excel Edition – in the drop-down you will see your report

• Create a grid report which I want to save as a favourite and share with other Excel Edition users

This is intended as a way for Excel Edition users to share favourites. To enable this you publish them to the web rather than save locally.

1. Create grid report and in Report Designer click Favourites icon highlighted 2. You will be prompted to enter a name:

3. You can make it a Web favourite by clicking Web button – you will then be prompted to enter the name of the web server and folder.

All users who have appropriate Repository permissions will be able to access these Web Favourites through XLCubed Excel Edition. 4. Click Favourites icon in XLCubed Excel Edition and then click Web Favourites.

5. Click Connect to connect to your web server and you will be able to browse the Repository and select your report.

  Create a grid report which I want to save as a favourite and share with other Web Edition users The best way to do this is to create a new folder on the Web Edition with an appropriate name (e.g. Web Favourites), and then publish a series of starting point grids into this folder. Users can then open these up on the Web Edition as needed. 1. Create a grid report and Publish Workbook to Web 2. At Publisher window – to create this shared Favourites folder – right-click to create

I have created a top-level folder called WebEditionFavourites which all my team members have permissions to access.

3. Publish report to this folder. Your users can then use this report as a starting point template.

  Create a workbook template that I can save as a favourite and share with other Excel Edition users This will allow you to publish the current workbook as a template to Web Edition. This can then be accessed and used as a starting point by users of XLCubed Excel Edition. Create your workbook template and then select Publish Workbook as Template under Publish to Web icon

You will see the normal Publisher window and the Published Templates folder. You can right-click and add new top- or sub-folders as required.

Give the template a name and click Publish. The next time an Excel Edition user wants to this template they can access it from Favourites, Open Template. Connect to browse the Repository and they should see the templates stored in the Published Templates folder:

Select one and OK and they will be prompted to save their copy of the template workbook. Once saved they can make changes as required.