Add data but disallow the deletion of the original data
Is there are a way to let users add on data to a spreadsheet but
disallow them to modify/delete the original data?
lock the cells to be protected>unlock the cells allowing changes>protect
"Adrian" <firstname.lastname@example.org> wrote in message
> Is there are a way to let users add on data to a spreadsheet but
> disallow them to modify/delete the original data?
You...How to I incorporate SD from a data series into chart error bars?
I have means of values that are in a line chart. I want to add error bars,
however when I add the error bars with SD=1 they all look the same. I know
the SD for each mean is not the same. I want to know how to get the error
bars to represent the SD of the data set (the set from which the mean was
derived) and not all look the same.
Set the 'Error amount' option to 'Custom' and specify the range in your
worksheet that has the SDs.
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In ar...Outlook Data Collection for A2007
I am trying to set up data collection. Outlook and Access 2007
While in Access I get message:
The Microsoft Office Access Outlook Add-in is disabled in Microsoft Office
Outlook 2007....verify that it is installed.......
I am looking for the file name so that I can locate the Add-in.
"Tom Ventouris" <email@example.com> wrote in message
>I am trying to set up data collection. Outlook and Access 2007
> While in Access I get message:
> The Microsoft Office Access Outlook Add-in is disab...Pivot table and counting.
I have a pivot table that gives me the number of rides done by a van. I can
have the pivot table return the number of rides, but what I need is the
number vans that participated for a certain day. Example, it is possible to
have 27 trips done by 18 vans, how can I count the number of vans and not
addup the van number?
Any help appreciated.
We need a bit more information on how your source data table is set up.
What information do you have in each column?
sacredarms <firstname.lastname@example.org> wrote:
> I have a pi...how to make cells automatically format to entered text size?
i am new to excel and i would like to have it resize the cells automatically
to the size of the text i entered. i know if i click on a cell and do format -
line break it does it for one cell. but how can i have excel do this
automatically for every cell in every workbook?
Hit CRTL + A to select all cells.
To make this the default for all new workbooks and sheets....
Open a new workbook. Customize as you wish. File>Save As Type: scroll down
to Excel Template(*.XLT) and...Best approach, Editing existing data.
Hi, I have a workbook with 2 sheets in it. One called master the othe
called data. I have created an input userform that takes the data an
puts it into the data sheet. I now need a way to bring up that sam
data to be able to alter it.
All the data for each vendor , with the vendor name first, is on on
line in cells a1, b1, c1 etc...
I have a combobox with the linked cell at c14 on my master page wher
the name of the vendor I want to edit will appear.
I need a way to edit that data. Any Ideas
Message posted from http://www.ExcelForum.com
...text box printing problems
I have created text boxes using the tool bar, however when I print the sheet
or even print preview it moves all the text boxes to the left when it returns
to the normal view. I do not want them to realign, but have tried everthing
and can not figure out why they are doing this.
Controls move to the left of the worksheet in Microsoft Excel 2002
But Jim Rech recently posted this:
This article is now obsolete. Since the 10/12/2004 security patch
there is no need to get a hotfix (although this article does not directl...Cycle Counting
I am looking for ideas on how to cycle count serial
number tracked items without increasing workload. Our
serialized items are barcoded but the problem is the are
situated on the pallet incorrectly and the pallet is
placed on a third level of a racking system.
If we could just cycle count based on item count
and not include the serial number it would make it easy.
Is this possible in Great Plains. We are running Great
Any suggestions are greatly aprreciated.
...Import text file from MS Word into MS Publisher.
I have created a text file in Word and a photo file in Publisher and would
like to merge the two. When I imported Word, it seemed to be totally
separate from the Publisher document - 7 pages of Word and 8 pages of photos.
I want the Word pages to precede the Publisher pages.
How is this done?
>I have created a text file in Word and a photo file in
Publisher and would
>like to merge the two. When I imported Word, it seemed to
>separate from the Publisher document - 7 pages of Word and
8 pages of photos.
>I want the Word pages ...comparing data #2
I was wondering is there a way to compare data from 2 columns in a side
by side comparison. I have a large list of numbers and what I want to
do is copy another list of numbers into the spreadsheet. But I want the
numbers in cell A1 and B1 to be equal if they are is not a match then
leave cell b1 empty. I want that to continue all the way through the
Do you want to end up with 2 separate columns, or are you wanting to
merge the 2 lists into 1 list, without duplications?
I want 2 side by side columns. With the numbers that are equal right
next to each othe...Adding Text to Charts
I have created a chart in Excel that tracks one of the
stock indexes. I have been able to point arrows to
specific days and add text so I know what was the reason
the stock index was up or down on that day.
However, as my chart expands the arrows and text are no
longer associated with those day I initially intended it for.
Is there any way in Excel to associate text with specific
day and have it attached so that if the chart grows or
shrinks it will always be associated with that particular day.
The trick is to group the graphic element and the chart. When adding a
I would like to know how which formula I should use to count some codes & to
ignore the duplicated codes, for example in column A:
Now, I want Excel to count & the result is 3 which are:
Yes I can use PivotTable, but I would like to use a formula because I have
to deal with this every day.
I appreciate your support.
COUNTIF will do it.
=COUNTIF(Rng,Rng), where the criterion is the same as the range:
> I wo...Looking for Macro to load data from Access table
I need to code a button to delete data in a spreadsheet then reload
the data from an Access table. I'm a new excel user so I down know
where to start.
Maybe this will help
Regards Ron de Bruin
"Randy K" <email@example.com> wrote in message news:firstname.lastname@example.org...
>I need to code a button to delete data in a spreadsheet then reload
> the data from an Access table. I'm a new excel user so I down know
> where to start.
...How do I count the # of times a value reoccurs and plot it over ti
I wish to plot a number of errors made by each users and compare it over
time. I have a column of user ID's and a column of dates. I want the chart
to count the number of times each user ID appears and plot against it's
corresponding date. However, each time I try to do this, the chart appears
wrong. Any ideas?
In article <9595B2A1-8282-4AB3-8511-A6776E108164@microsoft.com>,
> I wish to plot a number of errors made by each users and compare it over
> time. I have a column of user ID's and a column of dates. I want t...Problem importing data to Money 2006
I'm importing data from Money 2000 into 2006 and the dates and quantities of
investment transactions are not transferred. I exported multiple accounts
within a file with File/Export and changed the file names to reflect the
account names (with .qif after them) to a removable flash drive. Followed
import instructions (File/Import), set up multiple accounts and moved them
as a group. The transfer appeared to be successful except date and
quantities were not present. Any ideas?
In microsoft.public.money, leahn wrote:
>I'm importing data from Money 2000 into 2...configure text box
I recently upgraded to Publisher 2003. I can't find how to configure text boxes to overlap each other and keep the text in the same position. In my old version, there was a "check" box in the format text box to allow for this. I've tried different wrapping options in 2003, but can't figure it out.
You never have been able to do this in any version of Publisher.
You are dreaming about a Text Box - never existed.
You either have to place one Text Frame on the Background (Ctrl+M) or
convert one to a graphic.
"If you don't know where you are going,
any road...Line count
I am working with a program called Dictaphone. We use Word 2007 in this
program. The line count on Dictaphone and the line count in Word 2007 are
different even though the Dictaphone text is retrieved from Word 2007. Why
would they be different?
What is the difference between virutal line count and physical line count?
...Simple...Update Text Box in Chart
I have a chart in an MS Excel worksheet and I would like to change the
value/caption of a textbox( Text Box 20).
I have only been able to change the title of the chart with the
.HasTitle = True
.ChartTitle.Text = "Summary of Report" & date() 'Add
Do I have to reference the chart or do I have to reference the textbox
If the shape is actual embedded in the chart object then something like,
ActiveChart.Shapes(&quo...Data Consolidate Limitation
Consolidate function is useful for budgetary consolidation purpose
However, if there are > 12 worksheets to be consolidated, then
consolidate function is unable to call back and consolidate say 45
worksheets as it has reached the max limit of consolidation ( ie 12
In this case, is there any options/alternatives available either on
excel function or excel vba to solve this problem ?
Thanks & Regards
Can you just run cosolidate on 12 sheets at a time. I have written very
simple macros (about 30 lines) that can consolidate unlimited number of
sheets...count number of characters in rich edit control
How can i count number of characters in rich edit control 2
If u mean controls of type Rich TextBox control, try
"Rahul" <Rahul@discussions.microsoft.com> wrote in message
> How can i count number of characters in rich edit control 2
EM_GETTEXTLENGTHEX, WM_GETTEXTLENGTH, WM_GETTEXT, EM_STREAM*
"Rahul" <Rahul@discussions.microsoft.com> wrote in message
> How can i co...Text to Columns 06-01-10
I have a column where I have names and surnames. I want to put name in one
column and surname in anoter column. In order to do this, I use Text to
Columns, but I have the following issue: if the cell contains for example
Juan Pérez, it works ok, but when the cell contains Juan De los Santos, it
assumes there are three surnames, and then put me one word in each column.
This is the result, with the example mentioned:
A B C D
Juan De los Santos
How can I indicate that...Outlook data file (pst) is much larger than as reported by Outlook !
My Outlook's pst file is 1.7GB, ie quite close to the danger zone (2GB).
When I ask Outlook for the size of
the folders and all other datas it only shows 1.1 GB total !
Is the file corrupted ? Maybe some remains of an older account ? Using
scanpst.exe I see no error or problem in this file.
Is there some kind of "purge" operation (other than brutal deletion) ?
NB : same problem seen in Outlook XP and Outlook 2003 for the same pst file.
Aloha C-A Berseth,
Have you tried compacting it yet? (right-click the root folder of the Personal
Folders File, ...Data Refresh
I have a table with several fields, but in particular
Student Number (test)
Last Name (text)
These fields show on my form called Parking form. These fields are locked. I
wish to allow the users to add/edit fields. So I have a cmd button that opens
a new form called add/edit new student form. There the user can edit or add
a new student then return to the main form. The problem is when you add a
new student. That student will not show in the parking form unless you do
shift F9. I assume a requery command is needed but I cannot figure out
I have two different datasets. Each with a common identifier. I need a
formula that will reference the identifiers in both datasets and count the
number of sales a particular agent made. Example. look up this identifier
in the other dataset and then give me the value that is 2 columns over from
the identifier in the second dataset.
See if this helps:
Microsoft Excel MVP
"Dave" <Dave@discussions.microsoft.com> wrote in message
>I have two...Pivot table won't updade data when refresh selected
I have a simple pivot table which works on data from a different sheet in the
same workbook. When I change the text on the data source and then click
refreh an the pivot table it doesn't update. The changes I am making are just
simple corrections e.g. changing lower case letters for upper case. Please