James Elliott wrote:
No one knows about DataPilot?
James
----- Original Message ----- From: "James Elliott"
<[email protected]>
To: "Users at OOo" <[email protected]>
Sent: Thursday, September 17, 2009 12:36 AM
Subject: [users] Datapilot error in Calc.?
I am president of an organisation and I am using a membership spreadsheet
sent to me by my predecessor, Peter, (who I cannot contact for the
moment
to help me solve this problem).
I have 4 new members to add ... i.e. I need to use 4 rows at the
bottom of
the spreadsheet to enter their data.
I have entered 2, but when I try and enter #3 I get this error message:
"You cannot change this part of the Datapilot table"
Peter did have the word "Filter" in that cell, and below it was a table
consisting of a short list of members he had obviously sorted
according to
some criterion or filter, but I wasn't interested in this filtered
list so I
deleted it all to make room for more records to be added.
It looks like Peter was using Datapilot (which I do not understand
yet) to
do something and even though I have cleared those cells of all visible
content there is obviously some non-visible content or reference to those
cells that is stopping me from entering data into them..
How do I get out of this please? ... so that I can use these 'Datapilot
cells' to enter membership records.
Many thanks, James.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
--------------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.5.409 / Virus Database: 270.13.102/2377 - Release Date:
09/16/09 17:49:00
The datapilot entries may have been deleted by simply highlighting the
cells and selecting "delete". This does not remove the datapilot, just
the data in the cells. Try right clicking a cell in the area where you
got the error. If it is part of a datapilot range, then you will get
the datapilot pop-up box. Select "Delete" to remove the datapilot.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
