• Products
    • Sage Intelligence Reporting
      • Enrolment
    • Velixo
      • Enrolment
        • Velixo for Acumatica
        • Velixo for Sage Intacct
  • Services
    • Consulting
    • Training
    • Development
  • Support
    • Support Overview
    • Create Support Ticket
    • Book A Session
    • Knowledgebase
  • About
    • About Us
  • Contact
  • Products
    • Sage Intelligence Reporting
      • Enrolment
    • Velixo
      • Enrolment
        • Velixo for Acumatica
        • Velixo for Sage Intacct
  • Services
    • Consulting
    • Training
    • Development
  • Support
    • Support Overview
    • Create Support Ticket
    • Book A Session
    • Knowledgebase
  • About
    • About Us
  • Contact
Quick Support
Book Demo

Enable the recipients of your distributed reports to interact with PivotTables like you do

By admin on October 12, 2016April 19, 2019

Have you ever distributed reports containing PivotTables and found that your recipients aren’t able to interact with them, only having a snapshot of the data? Wouldn’t it be great if they could have some of the same functionality you do, like the ability to filter, drill down, or add other fields that may be of interest?
Typically, when a recipient receives a workbook like this, opens it and tries to work with the PivotTable, they receive a message saying that the Table was saved without the underlying data, and needs to be refreshed in order to be updated.

Then, after clicking the Refresh button on the Data tab, they’re told that the PivotTable source file can’t be opened.

Getting around this is easy.  All you have to do is save the underlying data with the PivotTable, which is an option in its properties.
1.Before distributing your report, right click on your Table and select PivotTable Options.

2. Then, under the Data tab, check the box saying Save source data with file, and then click OK.

3. You can now go ahead and distribute your report.  Once a recipient receives it and opens it, they’ll first need to enable the content.

4. They’ll then receive a message saying that some of the workbook links can’t be updated. After clicking Continue they’ll be able to interact with the PivotTable.

One thing to note is that by saving the source data with the PivotTable, the size of the distributed file will increase.  This is something to keep in mind if working with really large data sets, or if using email distribution and file size limits are imposed by the service providers.
The post Enable the recipients of your distributed reports to interact with PivotTables like you do appeared first on Sage Intelligence.

Powered by WPeMatico

Post navigation

How to convert dates into the correct format in Excel
How to create a Tree Map chart in Excel 2016

Recent Posts

  • Why Working In Excel Works
  • Alchemex Welcomes Velixo 6 For MYOB Advanced
  • Welcome to Velixo Reports Version 4.2
  • Part 3 of 3: Learn how to create a Management Pack in Sage 50cloud Intelligence
  • Part 3 of 3: Create and customize reports easily with the Financial Report Designer

Search

Contact Us

Phone: +61 2 9890 2339
Email: sales@alchemex.com.au
Address: PO Box 212, Deaken West, Canberra, Australia, 2600

Products

  • Intelligence Reporting
  • Velixo Reports

Services

  • Consulting
  • Training
  • Development

About

  • About Us
  • Partners
  • Blog

Support

  • New Ticket
  • Community (Coming Soon)
  • Knowledgebase

Phone: +61 2 9890 2339
Sales: sales@alchemex.com.au
Support: support@alchemex.com.au

Facebook-f Linkedin

© All rights reserved Alchemex Pty Ltd 2020

Made with ❤ by Unfazed Ltd