Change Range of Data Source of a Data Pilot

Discuss the spreadsheet application
Post Reply
titule
Posts: 1
Joined: Thu Feb 25, 2010 3:50 pm

Change Range of Data Source of a Data Pilot

Post by titule »

Hi,

I have created a data pilot for a range on another page.
For some reasons (check if all source data is still included in the pilot, adding rows and or columns) I want to check and maybe modify the data source of the pilot.

Where/How can I see/modify the source of a data pilot?

Thanks
OpenOffice 3.1.1 / Windows 7 (64bit)
User avatar
Villeroy
Volunteer
Posts: 31279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Change Range of Data Source of a Data Pilot

Post by Villeroy »

You can't. But scenarios offer a more elegant solution. trigonometricScenarios.ods
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
mriosv
Volunteer
Posts: 651
Joined: Mon Mar 09, 2009 1:12 am
Location: Galiza (España)

Re: Change Range of Data Source of a Data Pilot

Post by mriosv »

There are two options to do this:
-Update to 3.2, lets to change the source range.
-Install the extension: DataPilotTools, this lets change the source range and recalculate all datapilots in the file at same time.
LibreOffice 3.5.4 AOo-3.4 on Win 7 Ultimate
Post Reply