Pivot Tables

danam531 · May 20th, 2002, 01:33 PM

I am trying to cut down the size of a file that has several pivot tables in it. When you right click on the table, and go to table options, what is "save data with table layout" for? I unclicked it hoping to save space, but I'm not sure if it needs to stay checked.

danam531 · May 20th, 2002, 01:51 PM

This file has about 8 pivot tables, its not that big of a file but its getting stuck on something. I have it set up to refresh the tables on open - it does the first maybe 6 fine but then gets stuck and I have to "end task" ctrl-alt-delete

Mark W. · May 21st, 2002, 03:32 PM

Are all of the PivotTables sourced from the same data?

danam531 · May 21st, 2002, 03:52 PM

yes they are

Mark W. · May 22nd, 2002, 12:11 PM

Then you can reduce the overall size of your workbook by going back to Step 1 of 4 in the PivotTable wizard and setting that option to "Another PivotTable". Ideally, do this for each of your PivotTables so that they are all sourced from the same PivotTable.

danam531 · May 22nd, 2002, 01:35 PM

Thanks, I did that...but I was still wondering what "save data with table layout" was for?

Mark W. · May 22nd, 2002, 01:43 PM

If this option is selected a copy of external data is stored with each PivotTable; otherwise, before you could perform drilldown or pivot the table you'd have to refresh the PivotTable each time the worksheet is opened.

As you might well imagine if your external data set is quite large (and, you have a lot of PivotTables) this can expand your worksheet's size considerably. When you source a PivotTable from another then this data is only stored "behind" the PivotTable that you designate at Step 1 of 4 in the wizard.

This is explained in the Excel Help topic, "About creating a PivotTable or PivotChart report from another PivotTable report". And, by right-clicking the "Save data with table layout" option.

[ This Message was edited by: Mark W. on 2002-05-22 12:51 ]

danam531 · May 22nd, 2002, 01:44 PM

OK, thank you!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 20th, 2002, 01:33 PM	#1
danam531 New Member Join Date: May 2002 Posts: 40	I am trying to cut down the size of a file that has several pivot tables in it. When you right click on the table, and go to table options, what is "save data with table layout" for? I unclicked it hoping to save space, but I'm not sure if it needs to stay checked.

May 20th, 2002, 01:51 PM	#2
danam531 New Member Join Date: May 2002 Posts: 40	This file has about 8 pivot tables, its not that big of a file but its getting stuck on something. I have it set up to refresh the tables on open - it does the first maybe 6 fine but then gets stuck and I have to "end task" ctrl-alt-delete

May 21st, 2002, 03:32 PM	#3
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Are all of the PivotTables sourced from the same data?

May 21st, 2002, 03:52 PM	#4
danam531 New Member Join Date: May 2002 Posts: 40	yes they are

May 22nd, 2002, 12:11 PM	#5
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Then you can reduce the overall size of your workbook by going back to Step 1 of 4 in the PivotTable wizard and setting that option to "Another PivotTable". Ideally, do this for each of your PivotTables so that they are all sourced from the same PivotTable.

May 22nd, 2002, 01:35 PM	#6
danam531 New Member Join Date: May 2002 Posts: 40	Thanks, I did that...but I was still wondering what "save data with table layout" was for?

May 22nd, 2002, 01:43 PM	#7
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	If this option is selected a copy of external data is stored with each PivotTable; otherwise, before you could perform drilldown or pivot the table you'd have to refresh the PivotTable each time the worksheet is opened. As you might well imagine if your external data set is quite large (and, you have a lot of PivotTables) this can expand your worksheet's size considerably. When you source a PivotTable from another then this data is only stored "behind" the PivotTable that you designate at Step 1 of 4 in the wizard. This is explained in the Excel Help topic, "About creating a PivotTable or PivotChart report from another PivotTable report". And, by right-clicking the "Save data with table layout" option. [ This Message was edited by: Mark W. on 2002-05-22 12:51 ]

May 22nd, 2002, 01:44 PM	#8
danam531 New Member Join Date: May 2002 Posts: 40	OK, thank you!