1<?xml version="1.0" encoding="UTF-8"?>
2
3
4<!--
5 ***********************************************************************
6 *
7 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
8 *
9 * Copyright 2000, 2011 Oracle and/or its affiliates.
10 *
11 * OpenOffice.org - a multi-platform office productivity suite
12 *
13 * This file is part of OpenOffice.org.
14 *
15 * OpenOffice.org is free software: you can redistribute it and/or modify
16 * it under the terms of the GNU Lesser General Public License version 3
17 * only, as published by the Free Software Foundation.
18 *
19 * OpenOffice.org is distributed in the hope that it will be useful,
20 * but WITHOUT ANY WARRANTY; without even the implied warranty of
21 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
22 * GNU Lesser General Public License version 3 for more details
23 * (a copy is included in the LICENSE file that accompanied this code).
24 *
25 * You should have received a copy of the GNU Lesser General Public License
26 * version 3 along with OpenOffice.org.  If not, see
27 * <http://www.openoffice.org/license.html>
28 * for a copy of the LGPLv3 License.
29 *
30 ************************************************************************
31 -->
32
33<helpdocument version="1.0">
34<meta>
35<topic id="textscalcguidedatapilot_updatetablexml" indexer="include" status="PUBLISH">
36<title id="tit" xml-lang="en-US">Updating Pivot Tables</title>
37<filename>/text/scalc/guide/datapilot_updatetable.xhp</filename>
38</topic>
39</meta>
40<body>
41<bookmark xml-lang="en-US" branch="index" id="bm_id3150792"><bookmark_value>pivot table import</bookmark_value>
42<bookmark_value>pivot table function; refreshing tables</bookmark_value>
43<bookmark_value>recalculating;pivot tables</bookmark_value>
44<bookmark_value>updating;pivot tables</bookmark_value>
45</bookmark>
46<paragraph role="heading" id="hd_id3150792" xml-lang="en-US" level="1" l10n="U" oldref="33"><variable id="datapilot_updatetable"><link href="text/scalc/guide/datapilot_updatetable.xhp" name="Updating Pivot Tables">Updating Pivot Tables</link>
47</variable></paragraph>
48<paragraph role="paragraph" id="par_id3154684" xml-lang="en-US" l10n="U" oldref="34">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>
49<section id="relatedtopics">
50<embed href="text/scalc/guide/datapilot.xhp#datapilot"/>
51<embed href="text/scalc/guide/datapilot_createtable.xhp#datapilot_createtable"/>
52<embed href="text/scalc/guide/datapilot_edittable.xhp#datapilot_edittable"/>
53<embed href="text/scalc/guide/datapilot_filtertable.xhp#datapilot_filtertable"/>
54<embed href="text/scalc/guide/datapilot_grouping.xhp#datapilot_grouping"/>
55<embed href="text/scalc/guide/datapilot_tipps.xhp#datapilot_tipps"/>
56<embed href="text/scalc/guide/datapilot_deletetable.xhp#datapilot_deletetable"/>
57</section>
58</body>
59</helpdocument>
60