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...Pivot Table #62
Can I make form different Pivot Tables in two different sheets One, new pivot
table? If I can - how?
Please help me
...Spelling takes about 3 minutes to pass any single word check
I am using MS Outlook 2000.
The Spelling tool takes about 3-5 minutes to pass a single word check. This
problem happens when the email has attachment.
Any idea would be appreciated,
...Pasting chart on word
I can not copy a chart from excel and paste it in word but I can do the same
with excel tables.
Sorry: this newsgroup is for questions about Access, the database product
that's part of Office Professional.
You'd be best off reposting your question to a newsgroup related to Word, or
one related to Excel.
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
"imran" <email@example.com> wrote in message
>I can not copy a chart from exce..."Can't open this item" in Outlook outbox for Internet addresses
I've got an Exchange 5.5 server SP4 on NT4 running normally for years.
Recently when users send email to Internet addresses the email gets "stuck"
in the Outlook outbox. When one tries to delete the message there is no
response from Outlook. When one tries to open the message the message "Can't
open this item" is displayed.
I have uninstalled and reinstalled the Internet Mail Service on the server
with no result. But, when I stop and restart all of the Exchange services
something happens: the message still cannot be sent but I can open it and
Hel...copying from Word to Excel
I am trying to copy a line of data from a Word document into an Excel cell.
When doing so it is configured incorrectly.
In the box where normally you would find the cell address such as B58, it
says OLE-LINK2 and I can't seem to remove it.
Does anyone know what this is?
if you don't need a link just copy the data in Word and insert it with
'Edit - Paste special' (and choose something like 'Text only')
"ann" <firstname.lastname@example.org> schrieb im Newsbeitrag
news:0F296D6C-CAB1-4A41-8E96-89EB94E4C53C...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
...Outlook: I keep getting MS Word appearing interrupting work
Have installed outlook 2007 standard, all ok. Except, Outlook uses MS Word
as it's email editor, which I like. But there appears on my system a MS Word
'frame' which seriously gets in the way of working. sometimes it appears
behind outlook and blocks the background, sometimes it i selected instead of
outlook and so I cannot select anything in outlook without re-focussing on
outlook. It's highly annoying. Can anyone tell me how to get rid of it? I
still want to use word as my email editor, but don't want the ghost frame
that it creates......
Can anyone help me, please?
I working with a linked table on Access and one of the column are set as
text but I want to change to Memo but it is not allowing to do it.
You can't change the field properties of Linked tables. You have to make
that change from within the "parent", i.e., the file you are linking to.
"Vanessa Simmonds" <VanessaSimmonds@discussions.microsoft.com> wrote in
> Good Evening,
> Can anyone h...unwanted formatting (Word 2007)
I have a template in Word 2007 that does a mailmerge with a .CSV file.
The CSV file contains fields with document names (p.e. "ST 900.docx").
During the merge, the contents of these small documents is inserted.
The documents are made in Courier 12.
The template is also in Courier 12 and the default font in Normal.dotx
is also Courier 12.
After the merge, in the "output" document, the layout of the inserted
text is completely messed up:
in one line the font changes from Courier to Times New Roman and back
and the text will be bold where it is not in the ...PIVOT TABLE ALL option
Is there any way to remove the "All" option that comes in the page
fields in a pivot table??
Nope... All is there to stay...
> Is there any way to remove the "All" option that comes in the page
> fields in a pivot table??
As Jim said, you can't remove the "All" option in the page field. With
programming, you could select another item if the user selects "All".
For example, the following code is stored on the worksheet's code module:
Right-click the sheet tab, and choose Vi...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?
...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...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...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...I keep getting dialog box is open error in Word 2003.
Everytime I go into MS Word I get an error that says my dialog box is open.
I have to click ok then I can go in. How can I get rid of this error?
Disable the Office Plug-in option in Norton Antivirus (or other AV that you
may be using).
Terry Farrell - MSWord MVP
"Tracey F" <Tracey F@discussions.microsoft.com> wrote in message
> Everytime I go into MS Word I get an error that says my dialog box is
> I have to click ok then I can go in. How can I get rid of this error?
...Why does Word crash?
OK, so I had imbedded an excel spreadsheet in a word document, but each time I open the excel document up to change things in it the application crashes. <br><br>When I do this on the PC version, it works OK <br><br>WTF?
Make sure your Office software is fully updated, then run Disk Utility -
Repair Disk Permissions & restart your Mac. If that doesn't correct the
problem provide any additional details you can supply.
On 12/20/09 11:43 PM, in article 59baf7cb.-1@webcrossing.JaKIaxP2ac0,
&q...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...Is it possible to track changes in Publisher 2003 as in Word ?
I wish to use the tracking facility in Word in Publisher 2003, however I
cannot seem to work out how to do it. Can anyone help ?
No can do.
"sallyh8" <email@example.com> wrote in message
>I wish to use the tracking facility in Word in Publisher 2003, however I
> cannot seem to work out how to do it. Can anyone help ?
...Attachment error opening Word in Outlook
Error of : The document name or path is not valid. Try
* Check the file permissions fo rthe document or drive.
*Use the File Open dialog box to locate the document.
The file does eventually open after three error boxes pop
up. It is not an HTML file or anything listed on the
knowledgebase. Anyone have any ideas? If not, probably
will reinstall office 2000.
...Word Template Integration With AD
Hopefully someone will have an idea of how to do what I'm trying to do. We
use custom templates for MS Word 2003. The templates contain user names so
when creating a letter, we can populate the info (address, etc)
automaticatically once a name is selected. The problem is that we have to
manually edit the Names.doc file everytime we have a new user or name change,
etc. Is there any way to get the info to be pulled directly from Active
Directory so everytime a change is made in AD, it is also made in the
Thanks in advance for any replies received.
Yes that i...Where did Word and Works newsgroups go?
Anyway I believe this is a Windows XP problem dealing with MS Word 2000.
When I copy into Word 2000 from like IE6, Word will quit working with
the clipboard. Closing Word and reopening it will make it start working
About a year ago, I was testing a number of XP systems and stopped
updating Windows. This worked so well on my test machines that I stopped
all of the rest of them. So nowadays I only get hotfixes that actually
fix a problem that I am having. Although this one computer I restored
from the Recovery CD just last week. And there are no new updates on it
...Opening Outlook causes open Word
I have a user that he opens Outlook 2003 and this action cause that
Word's Windows open without reason.
Could somebody help me, please?
Thanks in advance!!
is he using word as his editor? Does he have any addins for word? When
outlook loads word to use it as the editor, the addin could be trying to
load and cause word to open completely.
Diane Poremsky [MVP - Outlook]
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/
Outlook Tips by email:
firstname.lastname@example.org...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?
...Presentation quality Excel tables?
After collecting many data, I want to summarize data into a table and
then put into both powerpoint and Word document for presentation and
Could anybody show me how to design a Excel table that really looks
great? Any templates? I designed a bunch of tables myself and because
I am lacking of artistic senses, my tables look ugly...
One requirement is that I have to make this data table in Black/White,
because in the report, mostly people print it out in Black/White, the
color will get distorted if it document is in color mode. To save
overall time, why don't I just de...