What's the minimum required for the pivot cache?

[David Thielen]

Hi;

If I want to create an XLSX with a pivot table but no cache (so it
re-calcualtes everything), what is the minimum I have to put in
pivotCacheDefinition.xml & pivotCacheRecords.xml?

thanks - dave


david@[email protected]
Windward Reports -- http://www.WindwardReports.com
me -- http://dave.thielen.com

Cubicle Wars - http://www.windwardreports.com/film.htm

 

[Jie Wang [MSFT]]

Hi David,

My understanding of your requirement is - you want the pivot table updated
each time it was opened, right?

If that was the requirement, then I think the refreshOnLoad attribute of
the pivotCacheDefinition element is what you're looking for. By setting
this attribute to 1 or 0, Excel will or won't refresh data when opening the
file.

Something looks like this:

<pivotCacheDefinition
xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"
xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships
" r:id="rId1" refreshOnLoad="1" refreshedBy="Jie Wang"
refreshedDate="40052.64866215278" createdVersion="3" refreshedVersion="3"
minRefreshableVersion="3" recordCount="277">

Note the refreshOnLoad="1".

If this is not what you want, please kindly let me know.

Thanks,
Jie Wang

Microsoft Online Community Support

Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
(e-mail address removed).

==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/en-us/subscriptions/aa948868.aspx#notifications.

Note: MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 2 business days is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions. Issues of this
nature are best handled working with a dedicated Microsoft Support Engineer
by contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/en-us/subscriptions/aa948874.aspx
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.