1<?xml version="1.0" encoding="UTF-8"?>
2
3
4<!--
5 * This file is part of the LibreOffice project.
6 *
7 * This Source Code Form is subject to the terms of the Mozilla Public
8 * License, v. 2.0. If a copy of the MPL was not distributed with this
9 * file, You can obtain one at http://mozilla.org/MPL/2.0/.
10 *
11 * This file incorporates work covered by the following license notice:
12 *
13 *   Licensed to the Apache Software Foundation (ASF) under one or more
14 *   contributor license agreements. See the NOTICE file distributed
15 *   with this work for additional information regarding copyright
16 *   ownership. The ASF licenses this file to you under the Apache
17 *   License, Version 2.0 (the "License"); you may not use this file
18 *   except in compliance with the License. You may obtain a copy of
19 *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
20 -->
21
22<helpdocument version="1.0">
23<meta>
24<topic id="textscalcguidedatapilot_updatetablexml" indexer="include" status="PUBLISH">
25<title id="tit" xml-lang="en-US">Updating Pivot Tables</title>
26<filename>/text/scalc/guide/datapilot_updatetable.xhp</filename>
27</topic>
28</meta>
29<body>
30<bookmark xml-lang="en-US" branch="index" id="bm_id3150792"><bookmark_value>pivot table import</bookmark_value>
31<bookmark_value>pivot table function; refreshing tables</bookmark_value>
32<bookmark_value>recalculating;pivot tables</bookmark_value>
33<bookmark_value>updating;pivot tables</bookmark_value>
34</bookmark>
35<paragraph role="heading" id="hd_id3150792" xml-lang="en-US" level="1"><variable id="datapilot_updatetable"><link href="text/scalc/guide/datapilot_updatetable.xhp" name="Updating Pivot Tables">Updating Pivot Tables</link>
36</variable></paragraph>
37<paragraph role="paragraph" id="par_id3154684" xml-lang="en-US">If the data of the source sheet has been changed, $[officename] recalculates the pivot table. To recalculate the table, choose <emph>Data - Pivot Table - Refresh</emph>. Do the same after you have imported an Excel pivot table into $[officename] Calc.</paragraph>
38
39<embed href="text/scalc/06/calcsamplefiles.xhp#pivot"/>
40<section id="relatedtopics">
41<embed href="text/scalc/guide/datapilot.xhp#datapilot"/>
42<embed href="text/scalc/guide/datapilot_createtable.xhp#datapilot_createtable"/>
43<embed href="text/scalc/guide/datapilot_edittable.xhp#datapilot_edittable"/>
44<embed href="text/scalc/guide/datapilot_filtertable.xhp#datapilot_filtertable"/>
45<embed href="text/scalc/guide/datapilot_grouping.xhp#datapilot_grouping"/>
46<embed href="text/scalc/guide/datapilot_tipps.xhp#datapilot_tipps"/>
47<embed href="text/scalc/guide/datapilot_deletetable.xhp#datapilot_deletetable"/>
48<embed href="text/scalc/guide/pivotchart.xhp#pivotchart"/>
49</section>
50</body>
51</helpdocument>
52