Why is Actual Work updated when entering time into Work Field?
We're using MS Project 2007 and seeing that sometimes when time is entered
into the Work field for a task, that task's Actual Work is updated to the
same value entered in the Work field. This happens to multiple resources,
but only on some of their tasks and not on others. For example, for the
weeks of 1/24 and 1/31, whatever hours I schedule (enter in the "work" cell
in the Resource Usage View) for a given task also appears in the "actual"
The tasks are setup up differently. Some are Fixed Work, some are Fixed
Duration. I believe all have the e...Excel 2003 spreadsheet. I enter the any number and it is entered.
If I enter a number into a cell it is put in like a decimal. For example, if
I enter 10 it is put in as .1 500 is entered as a 5
Goto Tools>Options and on the Edit tab you should see The Fixed Decimal
Places box checked. Uncheck it.
"maryu" <email@example.com> wrote in message
> If I enter a number into a cell it is put in like a decimal. For example,
> I enter 10 it is put in as .1 500 is entered as a 5
> Thank you
...Report: Dollar Value of Added Inventory??
Is there a report that can be run daily which gives us the dollar value of
inventory added (received) into the system on that day? Knowledge Base
article #869856 suggests running item/value list report and item/item
movement report subtracting the second report from the first, but doesn't
account for what was added that day.
...Filter records by date in subform by date entered in mainform.
Hello, I've spent 3 days trying to understand what I'm doing
wrong.....Here is the summary of my problem.
I have a form named 'frm_EfficiencyStats' and a subform within the
form named 'qry_Total hours subform' (the subform is based on a
query). The form contains a text box (for date) which is bound to a
I would like to be able to enter a date in the text box on my form,
and display the records in the subform based on the date I entered in
the text box. The subform will only pull records from my table based
on the date.
Here are th...columns in RMSSO
Is it possible to change the columns on the forms ??
Receiving po contains:
Type, Item Lookup Code, Reorder Number, Description, OtyOrd, QtyRTD,
QtyRcv, Cost, Price, NewPrice, Extended
Item Lookup Code, Description, MPQ, Price, BinLocation
We need to modify few other forms as well.
I think I've seen that in one of the add-ons while ago, but I cant
remember which one was it and I'm not 100% sure if I really did.
...Move a Column to rows
How can I move text that is in a column to rows
soddydj's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2571
View this thread: http://www.excelforum.com/showthread.php?threadid=39129
Try using Copy then Paste Special - Transpose
Copy the cells in the column you want to be in a row, go to the cell yo
want to paste the data and hit Edit, Paste Special and select Transpos
in the tickbox. Click ok
----------------------------------------------------------...Data Table in Clustered Column Charts
I have created a pivot table with these data:
Count of User Year
Unit 2006 Grand Total
A 10 10
B 8 8
C 7 7
Grand Total 25 25
After that I created a Clustered Column Chart, and I am able to create a
data table with the values as shown from the table.
I would like to include another set of data as follow:
Is there any way that I can include these data (which is in the same excel
screen) in the same graph?
...How To: copy dialogs from one project to another ?
Do you know how to copy a dialog used in one project to a
can I do this from outside IDE just copy files from one
directory to another ?
or do I need to copy manually inside IDE.
Thanks in advance for your help,
Tom Serface wrote:
> don't mess up the original. I do this all the time and it works really
Do you do it with VS .NET 2003? If you do, great, because it just means
my installation is broken in some way. If you don't, I suspect that if
you migrate to .NET 2003, you'll swear at it and stamp your foot as
much as I did when I fo...A script to replace a value with another
i want to replace a field with another within the same Contact record. Is
there any example that you can show me? i'll doing this to over 5,000
records. i'm using Outlook 2002, personal use.
Phone: (852) 9258 6600
...CRM 4.0 Email Attachment more than 8 MB
I have done the below steps to change the attachment size to 10 MB.
1.Open the application web.config (C:\Inetpub\CRM\web.config).
2. Locate the <httpRuntime> key within the <system.web> element and change
the values to the following:
<httpRuntime executionTimeout="9999" maxRequestLength="10240"/>
3. Locate the <httpRuntime> key within the <system.web> element of the
<location path='MSCRMServices"> element, and change it to the following:
4.Save and close the we...one advantage to '05
You can still use the software while it's updating online in the background,
even if you don't use a passport. I don't recall being able to do that in
the past with '04.
See the following link though for some problems observed
while working during an online update.
Have you experienced any of this Chris?
>You can still use the software while it's updating online
in the background,
>even if you don't use a passport. I don't recall...how to enter simple list and sum
using excel 2002 with an xp sp2 system
how would I enter a simple list of positive and negative numbers and then create a
cell with the sum of these values?
if the list would look like this
the output would look something like
In B1 enter =A1
In B2 enter =B1+A2
Copy down to B5
Gord Dibben MS Excel MVP
On Wed, 16 May 2007 06:34:13 +0300, "John" <firstname.lastname@example.org> wrote:
>using excel 2002 with an xp sp2 system
>how would I enter a simple list of positive and negative...Outlook Synch errors on one desktop client
I have tried a bunch of things but I still have one Outlook client that has
unknown errors when synching contacts.
I have tried the usual uninstall/reinstall of both the desktop client and
Outlook itself, deleting address book folders, setting the CRM options to not
sync contacts, restart Outlook, delete contacts, then restore the setting to
sync contacts, then attempt the sync again. No matter what I do the sync
stops after 47 contacts come over to Outlook.
The Local Data is set to - Full Name Has Data AND Status is Active. This
should bring ALL CRM contacts over to Outlook (~7...Replacing a value with symbol.
I wondered if there was a way to replace a value generated by a formul
in a cell with a symbol or an image, or even to automatically change th
color of the value in the cell.
To give you a better idea:
I want to calculate the change between to sets of values as
percentage and then replace the actual value eg. 10% with a symbol t
denote a positive or negative change (maybe an arrows up and down).
Firstly, is this at all possible?
Any help with this would be much appreciated, or if you have a bette
idea on how I could present this I would love to hear it too.
Mr Cli...Easiest Way to Move Column
I know I have seen this answer before, but I can't seem to locate it
this time. What is the easiest way to move a column of data to a
different column in one step, without overwriting any other columns,
and without having to first insert a column, and without having to go
back to delete the original column?
move your cursor under the column heading of the column you want to move and
hold down the RIGHT mouse button ... drag the column to its new location and
let go - you should get the option of SHIFT RIGHT AND MOVE ..
"Car...How can I organize multiple disc sets as one album?
I have been using iTunes for many years but I decided to give WMP a try since
I am using Media Center and also want a lossless codec.
I configured Media Player to automatically rip the CDs as I place them in
the drive. The process automatically creates a directory for each CD, even
when they are the same album. I really don't want to have multiple icons in
my album list, so what can I do to simply the layout after the tracks are all
I spent about 10 minutes renaming both icons with a common name and then
renumbering the tracks. I have about 45 more double albums t...Sorting 4 columns as one
I know how to sort a row of 2,000 random numbers. This
might take 40 pages if I only used one column per page.
???? How can I use and sort the full page (multiple
columns) where the date in column A line 50 would continue
to column C1? And c50 would continue on in E1 and so on?
Thanks in advance to the Excel expert.
Excel has very limited facilities for saving paper (fit to page, font, margins).
You will have to maintain your sheet as the 3 columns and snake
that into another sheet for display and / or printing. See
SNAKECOLS, How to snake columns to use fewer pages
...Resource Units for Tasks entered in PWA differs than tasks entered in Project 2007
I have an ePM user asking why if he enters a project task in PWA does
it not check the resource max units allocation the same way as when he
enters a task in Project Professional.
You have a project where resource A is 50% allocated. When you create
a task in Project Professional for this resource, the resource
allocation is set to 50%.
Create a task under the same project in PWA, submit and approve the
Open project professional and view the task information for the task
entered in PWA, why is the resource allocation set to 100% instead of
50% set for th...4.0 Upgrade
We are currently still on v1.2 due to multiple upgrade issues. Once those
issues are resolved, should we expect to have to upgrade to 3.0 before
upgrading to 4.0 (once it is released) or will we have the option to go from
1.2 to 4.0?
Upgrade from 1.2 to 4.0 will probably not be supported. The way to go is to
first upgrade to 3.0.
Merijn van Mourik
> We are currently still on v1.2 due to multiple upgrade issues. Once those
> issues are resolved, should we expect to have to upgrade to 3.0 before
> upgrading to 4.0 (on...Enter formula by code.
can anyone help. I cant seem to get this to work.
I keep getting run time error 1004
application or object defined error.
Public Sub TLIdentify()
finalrow = Worksheets("INV Bookings").Range("B65536").End(xlUp).Row
Worksheets("INV Bookings").Range("AV26:AV" & finalrow).FormulaR1C1 =
Regards and Thanks for any assistance.
Francis Brown...IF Function with Text values
Hi, I can't seem to get the IF formula to work with my spreadsheet. I have
two colums one with user login the other with surname and i need to pick the
surname out of the user login and i can't get the IF true or false to pick
out the surnames, any help very much appriciated.
use something like
> Hi, I can't seem to get the IF formula to work with my spreadsheet. I
> have two colums one with user login the other with surname and i need
> to pick the surname out of the u...CRM 1.0 installation
I am trying to install CRM 1.0 for the 1st time. It is on a Win2k Server(SP4) This is the order I followed
MS Exchange 2
MS SQL 2
I dont get any errors any where in the installation. However after the installation when I launch the application through IE I get the following erro
An error has occured. For more information, contact your system administrator
The Page addres it shows in the address bar i
PLUTO being muy machine nam
When I check the Application Log, this is the error against Microsoft CR
MSC...Entering a dollar amount w/out having to enter the decimal
What is the formula to have Excel automatically enter the decimal so all I
have to enter is the numbers?
It's one of the options you can specify. In Excel 2007, it's:
Excel Options...>Advanced>Automatically insert a decimal point
"Julieanne" <Julieanne@discussions.microsoft.com> wrote in message
> What is the formula to have Excel automatically enter the decimal so all I
> have to enter is the numbers?
...How do I count a range of numbers in a column
I am really stumped. I have a column of numbers that refer to locations on
the body and I need to count how many of these locations are on the face.
There are about 100 different numbered locations and I have 748 cells with
numbers in them. I need to count how many cells contain the numbers 1-5,
10-13, 60-69, 70-79, or 80-89. I can't seem to figure out how to get excel
formulas to let me count the range of numbers. Any help at all would be
try this. Just continue to add conditions. the + means AND.
Name your range as I have done.
=SUMPRODUCT((rn..."#VALUE!" Cell Value
Some of my cells are turning up the value "#VALUE!" in the cells.
I have duplicated the problem that I am having. A test worksheet.
I am using data in one work sheet, but, two table areas.
The second table is reliant of some data from the first table.
The intersecting result in the first table turns currency amounts, which is
what I want.
When data from the first table is left blank the intersecting data in the
turns up "#VALUE!". This of course is an ambiguous result that does not
have a purposed result.
If you feel you are able to assist with...