Pivot Table Data Crunching for Microsoft® Office Excel® 2007

Chapter 8. Sharing Pivot Tables with Others

<feature><title>In This Chapter</title>

• Sharing a Pivot Table with Other Versions of Office 189

• Saving Pivot Tables to the Web 191

• Publishing Pivot Tables to Excel Services 193

• Next Steps 199

</feature>

In the area of sharing your pivot tables with others, Excel 2007 took a giant step backward for all customers and a giant leap forward for select corporate customers.

All customers have the annoyance that pivot tables created in Excel 2007 cannot be used by customers using Excel 97 through Excel 2003. This chapter demonstrates the hoops that you must jump through to be able to share your pivot tables.

All customers have lost the ability to publish interactive pivot tables to a web page. If you were a fan ...