Palo Protect and Copy

N.B. Please read our disclaimer. Links to corporate servers or vendor-supplied documents do not constitute an endorsement of any vendor or their products or services.

TPF JEDOX PALO Protect and Copy Workbook

TPF Jedox Palo Protect and Copy

For most users the ability to bring data directly into Excel is a major benefit of Palo. However, this approach it is not without its attendant problems.

Users can inadvertently delete the PALO.DATAC() formulae
Users can copy values from other parts of the sheet destroying the PALO.DATAC formulae in the process
Users can try to copy data from one PALO.DATAC() formula to another and don’t understand why copying the PALO.DATAC formula doesn’t copy the value too.

T.P.F. have created a workbook that you can use as a starting point when you want to give your users the possibility of using PALO views with added protection and additional functionality.

Simply load the workbook, which only has a single tab. Use this tab as the target for your PALO Paste View and you will find that:

1. Drag and drop functionality, cut, copy, paste and paste special menu items and shortcut keys have all been disabled so you can’t delete, or copy over the PALO.DATAC formulae by mistake. They are only disabled in this workbook. Other workbooks that may be open will still function normally. (Although we would generally advise that you close other workbooks wherever possible when working with Palo views)

2. All entries to the PALO data area are validated so that you can only enter numbers, data spreads, “LIKE”s, “COPY”s or =Palo... formulae. In the current version you can’t enter text into string elements in a protected sheet.

3. You can copy values from one cell to another Palo.Data cell using the special Palo Copy button. Just put your cursor on the source value in a single cell, and then press the Palo Copy button. Select your target range and click OK - the value is now copied but the PALO formulae are unaffected.

Please Note:

The page labels and the row and column headers in the worksheet are NOT protected by this template and can still be edited / deleted.

The TPF Jedox Palo Protect and Copy Workbook is provided with no warranty (implied or otherwise). Your use of this free resource is entirely at your own risk. Your use of the resource implies your acceptance of these terms.

TPF JEDOX PALO PROTECT AND COPY WORKBOOK - REQUEST FORM

* Your Name:

* Your Organisation:

* Your Email Address:

* Confirm Email Address:

* Telephone:

* Your country:

Please add me to your PALO Features mailing list

Please send me the free Protect and Copy Workbook to the email address above

Please contact me regarding TPF’s consultancy services with PALO

* indicates a required field

Please note the free workbook will only be sent to organisational E-mail addresses. Please do not submit free E-mail account type addresses (e.g Hotmail, Gmail etc).

TPF Financial Budgeting Services

We can help you escape from spreadsheet Hell!

We can also integrate your financial plans with other business areas

If you want to replace silos of information with JOINED UP PLANNING contact us now!

We can also help you with advanced training on Jedox Palo and TM1 - the world’s most flexible modelling environments

To find out more about our services, click on the button below. We’ll be glad to help.

TPF Merchandise Planning Services

The Planning Factory offer a full service in all areas of merchandise planning

You may need:

An audit to measure the effectiveness of your current planning process

Assistance with implementation of 3rd party solutions

Design and implementation of custom solutions

A quickly implemented off the shelf solution

Training in merchandise planning concepts and techniques

Whatever your requirements, we will do our best to provide a solution that fits your business