Point mode in Edit data series
When I edit my data series on a scatter chart, cell mode goes to "Point".
This means for example that when I want to use the arrow keys to move between
the characters in the formula in "Series X values", the cell marker on the
spreadsheet moves and cellreferences are added to the formula.
I saw that if I press F2 the cell mode goes to "Edit" and now I can move the
marker between the characters using the arrowkeys. if I press F2 again cell
mode moves back to "Point"
However, for every time I edit my data series I need to press F2 to make it
behave...Cannot edit data in forms but can in tables
I have a problem!
I created a database where I can only edit the data in tables. In the forms
I created I can see the data but cannot edit the data.
I am using 2007 that I have set so the file can be opened in 2003. The data
was imported to create tables from two Excel spread sheets using the wizard.
The tables are linked together and the combined data is shown in a report.
This all works without a problem.
Now I need to edit the data, so I created several forms all of which I
cannot add, delete or edit the data.
I saw under the User and Group Permissions that u...how do I edit data in a primary table so that it will exist for a
how do I edit data so that records in primary table exist for all related
records in Access building table relationships?
On Sun, 22 Nov 2009 21:52:01 -0800, ginger <firstname.lastname@example.org>
>how do I edit data so that records in primary table exist for all related
>records in Access building table relationships?
It sounds like you have it backwards. Normally one would create the "parent"
record first, and then (using a subform, or other techniques) create "child"
records related to it.
That said... the relationships between r...Exchange 5.5
Hello to All -
We have a very small network that crashed due to virus problems and is now
NT 4 - SP 6a, Exchange 5.5 - SP 4, 5 clients (Win XP Pro, Win 98se, Win ME)
Only one of the clients (XP Pro) can still edit the data in our Public
Folders, which contains Outlook Contacts. When I check the client settings,
those for the one that works seem to be the same as those for the four that
don't. We need to be able to enter, edit and delete the data in Public
Folders from each of the clients.
All help will be appreciated,
...Edit data in charts
Sometimes edit data in Excel charts that are pasted in PP are grayed out ,
for example I have a PP that has 4 Excel charts 3 of them I can click on edit
data and change the data for the chart but one of the charts the option of
edit data is disabled . How can I enable this function?
it is likely that the source data link is broken.
do you have the original excel chart?
"Edward" <Edward@discussions.microsoft.com> wrote in message
news:78AEEF8F-FB58...How do I edit data categorylabels in a multi-level vertical axis?
...Edit data for Excel charts is disabled
I think I asked this question before but I can't find it now. I use VBA to
insert some Excel charts in PP 2007, sometimes the edit data option for
charts is disabled and I can't edit the data for that specific chart , any
suggestion how I can me it enable again?
...Edit data in saved for web workbook
I've saved for web a workbook using Office 2003, with interactivity selected. When I open the .mht file on a computer with Office 2003 I can edit the data. When I open the file on a computer with Office 2000, I'm able to open and view the file, but am not able to edit the data
I've downloaded and installed Office 2003 Add-in: Office Web Components and IE6 Service Pack
Are asp pages used to edit and delete database entries? I have many pages
for entry, but time to give access to making changes.
Yes. You can use the FrontPage Database Interface to create pages to edit
and delete records. Here are some resources to get you started:
~ Kathleen Anderson
Microsoft MVP - Expression Web
Spider Web Woman Designs
Expression Web Resources: http://www.spiderwebwoman.com/xweb/
Expression Web Wiki: http://expression-web-wiki.com/
FrontPage Resources: http://www.spiderwebwoman.co...Double Clicking On Cell To Edit Data
I modify existing cells contents quite frequently. Using the mouse and
double clicking seems to me to be extra work.
Is there any way via the keyboard to get into a cell to edit its
Jim Mac Millan
Cursor to, F2
"Jim Mac Millan" <email@example.com> wrote in message
> I modify existing cells contents quite frequently. Using the mouse and
> double clicking seems to me to be extra work.
> Is there any way via the keyboard to get into a cell to ...Edit Data
Hi, I have a set of data and I want to multiply each cell by 1000 s
want to add *1000 in about 30-40 cells together. is there any way to d
it quickly rather than going into each cell manually and enterin
Thank you :confused
Message posted from http://www.ExcelForum.com
try the following
- enter 1000 in an empty cell
- select and copy the cell (CTRL+C)
- select your data range
- goto 'Edit - Paste Special' and choose 'Multiply'
> Hi, I have a set of data and I want to multiply each cell by 1000 so
> want to add *...Edit Data with a Data Access Page
Hoe do I set a Data Access Page to allow data edits and entry?
Common reasons why a DAP doesn't allow editing of the data:
You must define the Unique Recordset property for the page's section that
has the data.
You must have an element bound to the table's primary key field. It can be
hidden, but it needs to be on the Data Access Page if you wish to edit data.
You must use an updatable query for the recordset (note: Data Access Pages
are more picky in what's updatable and what's
not -- a query that works in a form may not work in a page).
<M...Can't edit data in query
Hi everyone. Using A02 on XP. This may be a dumb question but I have a
UNION ALL SELECT SQL query showing me all records from 3 tables
[tDistributions], [tDistributionsArchive] and [tDistributionsArchiveOld].
Why can I not edit any fields?
I receive an Excel file with uncashed check numbers, date mailed and payable
to. I have to search through all distribution records to identify which
distribution record's check did not cash yet so we can pursue payment.
Because the tables are old and inherited, my unique identifier is only unique
in 2 of the tables so there is a bit of sea...Can no longer cut/paste ranges in chart "edit data" fields?
In Excel 2007 I can no longer cut/paste cell ranges into the x and y datasets
using the edit data tool. Is there a way to turn this back on?
Also the chart range resets itself to the current length of the data,
however, in many instances I want to set an exact future range. Is there a
way to have excel not reset the range to what it "thinks" I want.
> In Excel 2007 I can no longer cut/paste cell ranges into the x and y
> using the edit data tool. Is there a way to turn this back on?
I have no problem doing what you can't. Could you provide more det...Edit datalabel positions in a protected chart
I have a password protected chart. Users print it but do not edit it.
Now, I want them to be able to edit only the position of the datalabels.
How would I do it? Please help.
I don't believe XL supports that fine a level of control over charts.
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article <936885B6-FF62-4724-87CC-C1854EE82865@microsoft.com>,
> I have a password protected chart. Users print it but do not edit it.