James Elliott wrote:
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]
Try pushing the "next" 2 lines down by clicking Insert/Rows. Maybe this
will expand the area and now mess-up the Pivot Table.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
