Home > Cannot Change > Cannot Change This Part Of The Datapilot Table

Cannot Change This Part Of The Datapilot Table

Can you help me? For a quick solution, they'd like to enter the sample quantities in the Values area of the pivot table, instead of creating records in the source data. Hi Marcia, The message indicates that you are trying to change data which is part of a DataPilot generated area (in Excel speak like a DataPilot is like a PivotTable). Hi Marcia, The message indicates that you are trying to change data which is part of a DataPilot generated area (in Excel speak like a DataPilot is like a PivotTable). check over here

Any help is appreciated. I don't > remember protecting the document. When someone double-clicks a cell, I'm using VBA to update the SQL data source based on a hidden key column. Then it worked 4.0.

Tim Reply Ashenafi says: November 26, 2015 at 7:01 am I had a similar problem today and came looking for a solution. He is a media educator and most recently successfully migrated to university teaching, working as a visiting lecturer/instructor in journalism and new media at the University of the West of England. marcia.craftaholic Reply via email to Search the site The Mail Archive home users - all messages users - about the list Expand Previous message Next message The Mail Archive home Add

Changing status to Confirmed. Can I do it with OpenOffice? Please Note: this e-mail address is only for reporting problems with Apache OpenOffice (AOO) Bugzilla. Please reply to [hidden email] only -- CPH : openoffice.org contributor Maybe your question has been answered already?

It's not asking for a password. Description raal 2009-04-17 23:40:17 UTC 1 - write heading of table - see file reklstav.ots, sheet "data" 2 - select columns A:O 3 - Data - DataPilot - Start 4 - Considering this issue as of very low importance. --> P5 Format For Printing -XML -Clone This Issue -Top of page This is Apache OpenOffice (AOO) Bugzilla: the Apache OpenOffice (AOO) bug This is > a spreadsheet I created a month ago and have not had open since.

Changed in openoffice.org (Ubuntu): status: New → Confirmed Christopher M. Version: 7.1.375 / Virus Database: 267.14.23/240 - Release Date: 1/25/2006 --------------------------------------------------------------------- To unsubscribe, e-mail: [hidden email] For additional commands, e-mail: [hidden email] marcia.craftaholic Reply | Threaded Open this post in threaded If the data source changes either adding items or removing them the values I've entered now show up all over the table. I don't> know what happened, but I really need to be able to change data and> formulas.Hi Marcia,The message indicates that you are trying to change data which is part of

Now I do remember making a pivot table in the spreadsheet at some point. ----- Original Message ----- From: [hidden email] To: [hidden email] ; [hidden email] Sent: Tuesday, January 31, Affecting: openoffice.org (Ubuntu) Filed here by: nick_s When: 2010-06-13 Completed: 2011-04-26 Target Distribution Baltix BOSS Juju Charms Collection Elbuntu Guadalinex Guadalinex Edu Kiwi Linux nUbuntu PLD Linux Tilix tuXlab Ubuntu Ubuntu It's not asking for a password. See http://www.ambience.sk/open-office-text-number-format-conversion for a simple way to do this.

I don't > know what happened, but I really need to be able to change data and > formulas. check my blog A Closed Issue is a Happy Issue (TM). Description peter.junge 2004-11-12 16:56:21 UTC create datapilot table -> go to a cell with a functional element (e.g. To allow manual entries for the sample quantities, you could create a calculated item with the name Samples, as described below.

Reply James says: July 30, 2014 at 8:08 pm I use Excel 2013 at work, and tried your method. Free forum by Nabble Edit this page Skip to site navigation (Press enter) Re: [users] re: "you cannot change this part of the DataPilot Table" CPHennessy Tue, 31 Jan 2006 16:05:14 Posted by: JZA | August 27, 2008 at 01:10 AM Hi I´ve a doubt. this content As soon as you fill some data in the source range, everything is fine again.

If you don't select one of these cells, you won't be able to create a calculated item for that field. This higher end solutions like goalseek, subtotals, Validation, detective are great when someone can see the whole process work. Comment 3 falko.tesch 2004-11-16 09:20:43 UTC FT: Set to later and changed prio.

I don't know what > happened, but I really need to be able to change data and > formulas. >

This is a spreadsheet I created a month ago and have not had open since. I use Excel 2010 and following the steps outlined but it still does not allow me to enter an item/number in the pivot table. Andy also holds a master's degree in new media.Información bibliográficaTítuloBeginning OpenOffice 3: From Novice to ProfessionalBeginning OpenOffice 3: From Novice to ProfessionalExpert's voice in open sourceIT ProAutorAndy ChannelleEdiciónilustradaEditorApress, 2009ISBN1430215917, 9781430215912N.º de Checked by AVG Free Edition.

This is> a spreadsheet I created a month ago and have not had open since. Powered by WordPress. Posted by: Mirja | August 01, 2010 at 11:27 AM The comments to this entry are closed. have a peek at these guys Then the pivot table will need to be refreshed in order to pickup the change.

So if I want the color and formatting I can't change the analysis on the same table. This is a spreadsheet I created a month ago > and have not had open since. Reply Rich says: March 22, 2011 at 2:08 pm Does this work in 2003? Using OpenOffice 2.0, windows xp home. > ----- Original Message ----- > From: marcia.craftaholic > To: [hidden email] >

How can I do it if possible? lsb_release -rd Description: Ubuntu 10.10 Release: 10.10 sudo add-apt-repository ppa:libreoffice/ppa && sudo apt-get update && sudo apt-get -y upgrade && sudo apt-get -y install libreoffice-calc apt-cache policy libreoffice-calc libreoffice-calc: Installed: 1:3.3.0-1maverick1 I should note that I imported data from an Excel spreadsheet into OpenOffice, and could not get the pivot table feature to work. Regards, Andrew Format For Printing -XML -Clone This Issue -Top of page This is Apache OpenOffice (AOO) Bugzilla: the Apache OpenOffice (AOO) bug system.

In case of problems with the functioning of Apache OpenOffice (AOO) Bugzilla, please contact [email protected] All Rights Reserved. I don't> remember protecting the document. Checked by AVG Free Edition.

You will arm yourself with OpenOffice.org 3.0 tools, from creating wiki docs to automating complex design steps. I tested it and found that while I could change the value, I was not able to use Excel formulas to calculate the new value. Checked by AVG Free Edition. It is an end product and shouldn't be edited directly. -- Fred --------------------------------------------------------------------- To unsubscribe, e-mail: [hidden email] For additional commands, e-mail: [hidden email] CPHennessy Reply | Threaded Open this post

Comment 2 peter.junge 2004-11-15 14:58:52 UTC @FT: We should re-specify this in a later release I think. Tips for using, transitioning, and more. Does this work for you? Change the Values After you create the calculated item, it's automatically added to the pivot table, and you can change the values.

Thank you, Marcia No virus found in this outgoing message.