Project 2007 - Reset Task Durations
I am running Project locally, not on a server. Suppose I want all of the tasks to be changed to 7.5 hr calculation or 37.5 hr week. Will it work to assign the entire project and sub-tasks all to 7.5 hrs/37.5 hr week or do I need to do all individual tasks that way? In other words, what’s the highest level that I can set the tasks to this setting? And what is the best way to do this?
|
0 |
|
Utf
4/5/2010 8:20:44 PM
project
1276 articles. 
0 followers.
5 Replies
1463 Views
Select all tasks you want to change to the same value, then click the Task information icon (or Shift+F2). Fields you can't set are grayed out. -- Rod Gill Microsoft MVP for Project - http://www.project-systems.co.nz Author of the only book on Project VBA, see: http://www.projectvbabook.com "Carl" <Carl@discussions.microsoft.com> wrote in message news:D4173979-3ACE-4CCF-B07D-9E6487CD8EA9@microsoft.com... > I am running Project locally, not on a server. > Suppose I want all of the tasks to be changed to 7.5 hr calculation or > 37.5 > hr week. Will it work to assign the entire project and sub-tasks all to > 7.5 > hrs/37.5 hr week or do I need to do all individual tasks that way? > > In other words, what’s the highest level that I can set the tasks to this > setting? > And what is the best way to do this? > > > __________ Information from ESET Smart Security, version of virus > signature database 5002 (20100405) __________ > > The message was checked by ESET Smart Security. > > http://www.eset.com > > > __________ Information from ESET Smart Security, version of virus signature database 5002 (20100405) __________ The message was checked by ESET Smart Security. http://www.eset.com
|
|
0 |
|
Rod
4/5/2010 10:30:09 PM
Hi Carl, I'm not sure I understand your exact requirement. Your current durations are stored by Project in minutes. Say your current setting is 8H/day then a task showing as 5 days is in fact stored as 2400 minutes. Now do you want that task to SHOW as 5,33 days (of 7,5 hrs) which leaves its duration unchanged, or do you want its duration to CHANGE to 2250 minutes (i.e. 5 days �f 7,5 hours)? The first problem is simple enough, change Working Time to 7,5 hrs per day and in Tools, Options, Calendar, change hours per day and Hours per week to the appropriate number. The second problem cannot be solved through a setting, each task has to be changed. There is a simpel VBA procedure (macro) that can do that for you: Sub ChDur dim Job as task for each job in activeproject.tasks if not job is nothing then if not job.summary then job.duration=job.duration *7.5/8 end if end if next job end sub Hope this helps, -- Jan De Messemaeker Microsoft Project Most Valuable Professional +32 495 300 620 For availability check: http://users.online.be/prom-ade/Calendar.pdf "Carl" <Carl@discussions.microsoft.com> wrote in message news:D4173979-3ACE-4CCF-B07D-9E6487CD8EA9@microsoft.com... >I am running Project locally, not on a server. > Suppose I want all of the tasks to be changed to 7.5 hr calculation or > 37.5 > hr week. Will it work to assign the entire project and sub-tasks all to > 7.5 > hrs/37.5 hr week or do I need to do all individual tasks that way? > > In other words, what's the highest level that I can set the tasks to this > setting? > And what is the best way to do this? >
|
|
0 |
|
Jan
4/6/2010 6:58:23 AM
This is a multi-part message in MIME format. ------=_NextPart_000_004D_01CAD56A.CF8F86E0 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Hi Carl, Welcome to this Microsoft Project newsgroup :-) Also, you might like to see FAQ Item: 5. Default Working Hours FAQs, companion products and other useful Project information can be = seen at this web address: http://project.mvps.org/faqs.htm Hope this helps - please let us know how you get on :-) Mike Glen Project MVP See http://tinyurl.com/2xbhc for my free Project Tutorials=20 "Carl" <Carl@discussions.microsoft.com> wrote in message = news:D4173979-3ACE-4CCF-B07D-9E6487CD8EA9@microsoft.com... I am running Project locally, not on a server. Suppose I want all of the tasks to be changed to 7.5 hr calculation or = 37.5=20 hr week. Will it work to assign the entire project and sub-tasks all = to 7.5=20 hrs/37.5 hr week or do I need to do all individual tasks that way? In other words, what=E2=80=99s the highest level that I can set the = tasks to this=20 setting? And what is the best way to do this? ------=_NextPart_000_004D_01CAD56A.CF8F86E0 Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META content=3Dtext/html;charset=3DWindows-1252 = http-equiv=3DContent-Type> <META name=3DGENERATOR content=3D"MSHTML 8.00.7600.16535"></HEAD> <BODY style=3D"PADDING-LEFT: 10px; PADDING-RIGHT: 10px; PADDING-TOP: = 15px"=20 id=3DMailContainerBody leftMargin=3D0 topMargin=3D0 = CanvasTabStop=3D"true"=20 name=3D"Compose message area"> <DIV><FONT face=3D"Comic Sans MS">Hi Carl,</FONT></DIV> <DIV> </DIV> <DIV><FONT face=3D"Comic Sans MS">Welcome to this Microsoft Project = newsgroup=20 :-)</FONT></DIV> <DIV> </DIV> <DIV><FONT face=3D"Comic Sans MS">Also, you might like to see FAQ Item: = 5. Default=20 Working Hours</FONT></DIV> <DIV> </DIV> <DIV><FONT face=3D"Comic Sans MS">FAQs, companion products and other = useful=20 Project information can be seen at this web address: <A=20 href=3D"http://project.mvps.org/faqs.htm">http://project.mvps.org/faqs.ht= m</A></FONT></DIV> <DIV> </DIV> <DIV><FONT face=3D"Comic Sans MS">Hope this helps - please let us know = how you get=20 on :-)</FONT></DIV> <DIV> </DIV> <DIV><FONT face=3D"Comic Sans MS">Mike Glen<BR>Project MVP<BR>See <A=20 href=3D"http://tinyurl.com/2xbhc">http://tinyurl.com/2xbhc</A> for my = free Project=20 Tutorials </FONT></DIV> <BLOCKQUOTE=20 style=3D"BORDER-LEFT: #000000 2px solid; PADDING-LEFT: 5px; = PADDING-RIGHT: 0px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px"> <DIV>"Carl" <<A=20 = href=3D"mailto:Carl@discussions.microsoft.com">Carl@discussions.microsoft= ..com</A>>=20 wrote in message <A=20 = href=3D"news:D4173979-3ACE-4CCF-B07D-9E6487CD8EA9@microsoft.com">news:D41= 73979-3ACE-4CCF-B07D-9E6487CD8EA9@microsoft.com</A>...</DIV>I=20 am running Project locally, not on a server.<BR>Suppose I want all of = the=20 tasks to be changed to 7.5 hr calculation or 37.5 <BR>hr week. Will it = work to=20 assign the entire project and sub-tasks all to 7.5 <BR>hrs/37.5 hr = week or do=20 I need to do all individual tasks that way?<BR><BR>In other words,=20 what=E2=80=99s the highest level that I can set the tasks to = this=20 <BR>setting?<BR>And what is the best way to do=20 this?<BR></BLOCKQUOTE></BODY></HTML> ------=_NextPart_000_004D_01CAD56A.CF8F86E0--
|
|
0 |
|
Mike
4/6/2010 8:23:25 AM
Thanks all, I am now on the correct path. "Mike Glen" wrote: > Hi Carl, > > Welcome to this Microsoft Project newsgroup :-) > > Also, you might like to see FAQ Item: 5. Default Working Hours > > FAQs, companion products and other useful Project information can be seen > at this web address: http://project.mvps.org/faqs.htm > > Hope this helps - please let us know how you get on :-) > > Mike Glen > Project MVP > See http://tinyurl.com/2xbhc for my free Project Tutorials > "Carl" <Carl@discussions.microsoft.com> wrote in message > news:D4173979-3ACE-4CCF-B07D-9E6487CD8EA9@microsoft.com... > I am running Project locally, not on a server. > Suppose I want all of the tasks to be changed to 7.5 hr calculation or > 37.5 > hr week. Will it work to assign the entire project and sub-tasks all to > 7.5 > hrs/37.5 hr week or do I need to do all individual tasks that way? > > In other words, what’s the highest level that I can set the tasks to > this > setting? > And what is the best way to do this? >
|
|
0 |
|
Utf
4/6/2010 3:31:02 PM
This is a multi-part message in MIME format. ------=_NextPart_000_0010_01CAD5AB.56852250 Content-Type: multipart/alternative; boundary="----=_NextPart_001_0011_01CAD5AB.56852250" ------=_NextPart_001_0011_01CAD5AB.56852250 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable You're welcome, Carl=20 Mike Glen MS Project MVP See http://tinyurl.com/2xbhc for my free Project Tutorials "Carl" <Carl@discussions.microsoft.com> wrote in message = news:D5922B64-5BFC-4215-8FA9-9D51AE552EC7@microsoft.com... Thanks all, I am now on the correct path. "Mike Glen" wrote: > Hi Carl, >=20 > Welcome to this Microsoft Project newsgroup :-) >=20 > Also, you might like to see FAQ Item: 5. Default Working Hours >=20 > FAQs, companion products and other useful Project information can be = seen > at this web address: http://project.mvps.org/faqs.htm >=20 > Hope this helps - please let us know how you get on :-) >=20 > Mike Glen > Project MVP > See http://tinyurl.com/2xbhc for my free Project Tutorials > "Carl" <Carl@discussions.microsoft.com> wrote in message > news:D4173979-3ACE-4CCF-B07D-9E6487CD8EA9@microsoft.com... > I am running Project locally, not on a server. > Suppose I want all of the tasks to be changed to 7.5 hr = calculation or > 37.5 > hr week. Will it work to assign the entire project and sub-tasks = all to > 7.5 > hrs/37.5 hr week or do I need to do all individual tasks that way? >=20 > In other words, what=E2=80=99s the highest level that I can set = the tasks to > this > setting? > And what is the best way to do this? > ------=_NextPart_001_0011_01CAD5AB.56852250 Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META content=3Dtext/html;charset=3DWindows-1252 = http-equiv=3DContent-Type> <META name=3DGENERATOR content=3D"MSHTML 8.00.7600.16535"></HEAD> <BODY style=3D"PADDING-LEFT: 10px; PADDING-RIGHT: 10px; PADDING-TOP: = 15px"=20 id=3DMailContainerBody leftMargin=3D0 topMargin=3D0 = CanvasTabStop=3D"true"=20 name=3D"Compose message area"> <DIV><FONT face=3D"Comic Sans MS">You're welcome, Carl <IMG=20 style=3D"POSITION: static; MARGIN: 0px; FLOAT: none" title=3D"Smile = emoticon"=20 tabIndex=3D-1 alt=3D"Smile emoticon"=20 src=3D"cid:813579EC8CA74530AE8B3EDA37FE14F8@MikeSony"=20 MSNNonUserImageOrEmoticon=3D"true"></FONT></DIV> <DIV><FONT face=3D"Comic Sans MS"></FONT> </DIV> <DIV><FONT face=3D"Comic Sans MS">Mike Glen</FONT></DIV> <DIV><FONT face=3D"Comic Sans MS">MS Project MVP</FONT></DIV> <DIV><FONT face=3D"Comic Sans MS">See <A=20 href=3D"http://tinyurl.com/2xbhc">http://tinyurl.com/2xbhc</A> for my = free Project=20 Tutorials</FONT></DIV> <DIV><FONT face=3D"Comic Sans MS"></FONT> </DIV> <DIV><FONT face=3D"Comic Sans MS"></FONT> </DIV> <BLOCKQUOTE=20 style=3D"BORDER-LEFT: #000000 2px solid; PADDING-LEFT: 5px; = PADDING-RIGHT: 0px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px"> <DIV>"Carl" <<A=20 = href=3D"mailto:Carl@discussions.microsoft.com">Carl@discussions.microsoft= ..com</A>>=20 wrote in message <A=20 = href=3D"news:D5922B64-5BFC-4215-8FA9-9D51AE552EC7@microsoft.com">news:D59= 22B64-5BFC-4215-8FA9-9D51AE552EC7@microsoft.com</A>...</DIV>Thanks=20 all, I am now on the correct path.<BR><BR>"Mike Glen" = wrote:<BR><BR>> Hi=20 Carl,<BR>> <BR>> Welcome to this Microsoft Project newsgroup = :-)<BR>>=20 <BR>> Also, you might like to see FAQ Item: 5. Default Working=20 Hours<BR>> <BR>> FAQs, companion products and other useful = Project=20 information can be seen<BR>> at this web address: <A=20 = href=3D"http://project.mvps.org/faqs.htm">http://project.mvps.org/faqs.ht= m</A><BR>>=20 <BR>> Hope this helps - please let us know how you get on = :-)<BR>>=20 <BR>> Mike Glen<BR>> Project MVP<BR>> See <A=20 href=3D"http://tinyurl.com/2xbhc">http://tinyurl.com/2xbhc</A> for my = free=20 Project Tutorials<BR>> "Carl" <<A=20 = href=3D"mailto:Carl@discussions.microsoft.com">Carl@discussions.microsoft= ..com</A>>=20 wrote in message<BR>> <A=20 = href=3D"news:D4173979-3ACE-4CCF-B07D-9E6487CD8EA9@microsoft.com">news:D41= 73979-3ACE-4CCF-B07D-9E6487CD8EA9@microsoft.com</A>...<BR>>  = ;=20 I am running Project locally, not on a server.<BR>> = Suppose I=20 want all of the tasks to be changed to 7.5 hr calculation or<BR>>=20 37.5<BR>> hr week. Will it work to assign the entire = project=20 and sub-tasks all to<BR>> 7.5<BR>> hrs/37.5 hr week = or do I=20 need to do all individual tasks that way?<BR>> <BR>> = In=20 other words, what=E2=80=99s the highest level that I can set the = tasks=20 to<BR>> this<BR>> setting?<BR>> And = what is=20 the best way to do this?<BR>></BLOCKQUOTE></BODY></HTML> ------=_NextPart_001_0011_01CAD5AB.56852250-- ------=_NextPart_000_0010_01CAD5AB.56852250 Content-Type: image/gif; name="Emoticon1.gif" Content-Transfer-Encoding: base64 Content-ID: <813579EC8CA74530AE8B3EDA37FE14F8@MikeSony> R0lGODlhEwATALMPAPXv3v3pTvDHOei2K9u4a9qoLunPkLGLMdOZKfvbQMeyl5p4J+7JbrebXoAy GAAAACH5BAEAAA8ALAAAAAATABMAAASu8EkJDBNjMAOmf5UgJEGQJBj3AVfpuslAdBRDvu8p04YQ CIuFrzQIDgQFA2i4AAAWruYTgwiVFopnNCsUICy3hUMBvY67hcYwIHaU2Q43ZnAYuIDCUixYmC8G NzgmJyIZBQcXgYMnKIUDCA09jA4FgCcFCA4ZdFlHl5SbmQiGBx0GR0iZcXEIo5wUBH1ImK2tGQcN NCCxm70Dh7krBq2VvwgHB1kfExUNBwu4yh4RADs= ------=_NextPart_000_0010_01CAD5AB.56852250--
|
|
0 |
|
Mike
4/6/2010 4:05:20 PM
Similar Artilces:
2007 Structured Reference auto-completion not working completely?
In Excel 2007, when I: 1) Select a cell 2) Type "=" in the formula bar 3) Click a cell in a Table I thought Excel would add a Structured Reference to the formula. Instead, it just inserts an old-style, "A1" reference. The "Formula AutoComplete" and "Use table names in formulas" options are both turned on. When I click the cell in step 3, the TableTools tab appears so Excel agrees that the cell is in a Table. Isn't Excel supposed to insert a Structured Reference when you click a cell in a Table? Is there another setup/configuration switc...
Outlook 2007 Searching
Each time I do an Outlook 2007 search "Tools/Instant Search/Advanced Find" I have to press the Browse button and check the "Search Subfolders" box. How do I default to always have the "Search Subfolders" checked? Thanks On Mar 7, 9:44 am, "Jeff Roe" <jdru...@hotmail.com> wrote: > Each time I do anOutlook2007 search "Tools/Instant Search/Advanced Find" I > have to press the Browse button and check the "SearchSubfolders" box. > > How do Idefaultto always have the "SearchSubfolders" checked? Jeff, I c...
Deleted contact in Outlook 2007
I have a new Dell laptop with the #$@#$$%$ touchpad. It's been a week and I am still dragging stuff I don't want to drag and selecting stuff I don't want to select. AAARRRRRRGGGGGGG. Anyway, I had a contact open in Outlook 2007 and I did something with the touchpad and the contact disappeared. I don't know if I deleted it, renamed it, hid it, or what. Would I be able to delete it with just one errant touchpad action? Wouldn't it ask me to confirm it? I tried Ctrl-Z but Edit | Undo is greyed out. Will Undo undo a deleted contact? If I didn't delete it, where could i...
Task Manager and unsecapp.exe
When running Task Manager I recently found unsecapp.exe running. I am using XP Pro and have never has Vista on my machine, can I stop this program? It has used 26840K of memory. BillH On 11/25/2009 9:20 AM, Bill T wrote: > When running Task Manager I recently found unsecapp.exe running. > > I am using XP Pro and have never has Vista on my machine, can I stop > this program? Have you tried using Google to search for "unsecapp.exe" to see what you'd find? I just did and the first 4 sites listed were enough to satisfy my curiosity. -- R...
Outlook 2007 cached mode problem
Hi I do some support for a small company that has just installed their first seat of office 2007. They are running SBS 2000. When Outlook 2007 is set in cached mode no emails after February 7th show for the user and no new emails appear. If cached mode in turned off all their emails show. They were running Outlook 2002 on another machine previously which doesn't have cached mode so without trying it on 2003 I can't tell if it is a server or client problem. All other folders appear to be OK. Any suggestions? Has anyone else had this problem? I support this site remotely so exh...
Calculate cost of project against time worked
Hi everyone Have had a good look through various discussion groups for this and can't seem to find what I am looking for, I hope someone can help. I have a access 2000 database which captures projects coming into the department, each project is then resourced to a team member. When they have finished their part they put in how long it has taken them, from 1 hour (up to max of 3hours) then it goes up in 1/2 day increments to 15 days. At the moment I just have a drop downlist allowing them to pick, for example, 1/2 day, 1 day, 1.5 days etc, but now we have a set daily and hourly rate for...
word 97 covert to word 2007
old saved word doc. wont run in word 2003-2007 Files with insert pics okey. Some files will convert but 100 or so will show but not open Have tried many solutions , inc. repair Office Have you tried to repair the *documents* by using Open and Repair in Word 2007? -- Stefan Blom Microsoft Word MVP "2teddy5" wrote: > old saved word doc. wont run in word 2003-2007 > Files with insert pics okey. > Some files will convert but 100 or so will show but not open > Have tried many solutions , inc. repair Office ...
completed task triggers new task
Can you set up the task function in Outlook to create a new task once a "master task" has been completed? What kind of new task? In the form of a recurring task? You can then configure the Recurrence Pattern on the task. -- Robert Sparnaaij [MVP-Outlook] Coauthor, Configuring Microsoft Outlook 2003 http://www.howto-outlook.com/ Outlook FAQ, HowTo, Downloads, Add-Ins and more http://www.msoutlook.info/ Real World Questions, Real World Answers ----- "Sherri" <Sherri@discussions.microsoft.com> wrote in message news:DED33B01-1A25-4181-B062-FD416472C589@microsoft....
Powerpoint 2007 01-14-10
Any chance you know how to REVERSE the order of the bullets (in the old version you could go 10 – 1) ...
Ahead of Schedule task and % complete
If I enter a % complete value on a task that indicates it's ahead of schedule, how do I get MS Project to reflect an earlier finish time than originally expected? Here's a quick scenario: Let's assume I'm on a 2-week project with one task and one resource. Project starts on the first Monday and ends on the 2nd Friday. At the end of the first week, I enter a status date of Saturday into Project Information and a % complete of 80% on the task. Theoretically my project is 3 days ahead of schedule. Is there any way I can get MS Project to reflect that via levelin...
Outlook 2007 appointment durations
Is there any way that we can change the default duration of an appointment from 30 mins to 20 mins. Thanks, -- Michelle "Michelle" <Michelle@discussions.microsoft.com> wrote in message news:B2907478-E063-4EF4-96CA-935F2CC4CA9E@microsoft.com... > Is there any way that we can change the default duration of an appointment > from 30 mins to 20 mins. Set your calendar time scale to ten minutes (right-click an empty area of the calendar, choose Other Settings, and change the Time Scale drop-down), then preselect two time intervals before clicking New. Wi...
Changing default indents for lists (Word 2007)
In previous versions of Word this was relatively easy. I'm pretty adept with Office products, but as far as I can see this is no longer possible. Can someone confirm or enlighten me? I don't like the indents that Word 2007 imposes on bulleted and numbered lists -- it wastes a lt of space and for me is difficult to visually scan. I prefer my first levels of bullets (or numbers) to appear so that the bullet is lined up with the left margin with a hanging indent of 0.25". Then I like the second level of bullets to be at 0.25" with a hanging indent of 0.5", ...
Timesheet and Employee Expenses Approval by Project
I would like to suggest the approval workflow to be by project, right now in project accounting, the employee only can have 2 level of approval, ie, Supervisor and Manager, at most of my client that using Project Accounting, they are requesting the approval to be go by project, ie for the same employee that doing different project, their respective timesheet and employee expenses should route to the supervisor or manger that assigned to the project. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this ...
MS POS 2.0 and Office Account 2007
Has the integration been improved between these two applications since the SBA 2006 and POS 1.x were released? When I looked at it back it didnt do transactions, just batches. I am looking for full integration between the two products. Point of Sale 2.0 ships with Office Accounting 2007 for free. There is a very tight integration where detailed sales, item, customer, vendor, and item receipt information is shared automatically. This site has more info: http://pos.microsoft.com "DomitianX" <DomitianX@discussions.microsoft.com> wrote in message news:C6E30AA5-8D21-431...
Selecting multiple criteria in a report in Acc 2007 using a form
How can I select multiple criteria using a form to generate a report in Access 2007. -- Lady_Dee On Wed, 10 Mar 2010 17:38:04 -0800, Lady_Dee <LadyDee@discussions.microsoft.com> wrote: >How can I select multiple criteria using a form to generate a report in >Access 2007. By putting multiple instances of =[Forms]![NameOfForm]![NameOfControl] or other appropriate expressions on the Criteria line of a query, and use that query as the Recordsource for the report. For a more detailed answer please post a more detailed question. -- John W. Vins...
My Word 2007 Crashed Whenever I Open It 03-14-10
Whenever I open Word or click on a word file, the Word GUI opens and immediately stops responding. The file doesn't load, and none of the buttons can be pressed - I just see a word window without a document and toolbars which can't be pressed. What should I do in order to begin troubleshooting? Thanks. See the article "Problems opening Word” at: http://www.word.mvps.org/FAQs/AppErrors/ProbsOpeningWord.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, ...
Reset of PO, SO sequence numbers
GP 9, SP2, SQL Version. On separate occaisions, our P/O numbering sequence has been reset (to a lower number) as well as the S/O numbering sequence. Has anyone seen this before and know the cause? K It just happened to us last week, too (and has before). I don't know what causes it. "Ken D" wrote: > GP 9, SP2, SQL Version. > > On separate occaisions, our P/O numbering sequence has been reset (to a > lower number) as well as the S/O numbering sequence. > > Has anyone seen this before and know the cause? > > K Ken, For PO's, the only reas...
macro for repeat task and format interior
Hi All, I'm trying to check out repeated value on column Q and the hightlighted entire cell on the left.I put the code that found from Sample,and trying to modified it but I made a mistake.I can't select entire cell on the left, I just can highlight 2 cell ( offset(0.-3) and the cell on column A).Please help how to select entire cell to the left without interupted by blank cell. And also I want to put the copy of higlighted cell value to a new workbook. Thank's. Rgds, Shiro Sub Duplicate_Serial_Number() Dim eX As Integer Dim cell_in_loop As Range eX = ActiveSheet....
Auto Fill function in Excel 2007 not working properly
I cannot get the Auto Fill function to increase values in a series, and I feel certain I'm doing it right: First, I tried typing a series of values in a column like this: Cell A1, I typed 1. Cell B1, I typed 2. Then, I selected both cells with the mouse, and then moved to the lower right corner of Cell B1 and left-clicked and held the mouse button down. Then I dragged the mouse button down several columns. The little pop-up message seemed to indicate that it was repeating 1, 2, 1, 2. When I released the mouse button, it had actually filled a 1 in each cell! After several ...
DPM 2007 SP1 and Windows Server 2008 SP2 Hyper-V Failover Cluster
Should DPM 2007 SP1 be able to backup virtual machines that are in a Windows Server 2008 SP2 Hyper-V fail over cluster? Each VM has a dedicated LUN at this point in time. From previous experience the backups appear to be inconsistent from the stand point of if the machine is migrated to another host the backup breaks. Has anyone successfully implemented backups for this type of environment? DPM 2007 SP1 does officially support backing up VMs on Windows 2008 SP2 Hyper-V Clusters. -- Narendran[MSFT] This posting is provided "AS IS" with no warranties, and confer...
Default Weight in Pivot Table Charts keeps getting reset
Hi, I have created a Pivot Table chart and I am using basic line chart to display the data...I would like to make the line weight 2 points heavier than the standard but each time I select new values from the Pivot Table chart it resets to the default....where do you set this to remain at the values entered... Any help appreciated.... Scott ...
integration of project server 2007 and moss 2007
I have two server in one i have installed single server installation of project server 2007 in which and on the other server separately i installed moss 2007 and make Database server of MOSS 2007 is Project Server 2007. Now we can integrate Project Server 2007 and MOSS 2007 in this way and want to configure proposal workflow. Because i dont want to install moss 2007 in existing installation of project server 2007. I don't know Project Server, but your question is not clear as to what you are asking. -- Daniel A. Galant Imagine what we could be... if we co...
Printing Monthly Calendar (Outlook 2007)
My work has upgraded from Outlook 2003 to Outlook 2007. Every month I print off the monthly view so I can monitor regular events. Outlook 2003 monthly print option only displayed the current month (5 weeks). In Outlook 2007 I am getting a six week view which is compressing the meeting information and displaying some of the next month. Is there a way I can set this so I only get the current month ? -- Malcolm Do you have all the latest updates installed? Outlook 2007 should print exactly 1 month - but there was a bug in early builds and it always did 6 weeks. -- Diane P...
Weird message when opening Word 2007
Since upgrading to Windows 7, I'm getting a strange message when I open Word 2007, which I never got using previous Windows versions. It says: Word could not create the work file. Check the temp environment variable. When I click the OK button, Word opens up and there does not seem to be any problems, but I'd like to get rid of these messages. How can I do that? When Word starts it needs to create a raft of temporary files - some in the working folder, others in the User's temporary folder. The message suggests that Word cannot locate the temporary folder or that it c...
Outlook 2007 won't open
Sometimes I close Outlook 2007 when I'm working during the day and then when I try to open it it won't open. The other MS applications in the 2007 suite open OK all the time. It is only Outlook that does this - maybe 2 or 3 times a day. I have to re-boot to gain access to it again. If, after trying to launch Outlook 2007 I do a restart, the application opens momentarily before Windows logs off and the computer restarts. -- John F XPproSP2 Maybe OL isnt exiting correctly, and as such your Processes Tab will show an instance of Outlook.exe still running (Cntr+Alt+Del > ...
In Excel 2007, when I: 1) Select a cell 2) Type "=" in the formula bar 3) Click a cell in a Table I thought Excel would add a Structured Reference to the formula. Instead, it just inserts an old-style, "A1" reference. The "Formula AutoComplete" and "Use table names in formulas" options are both turned on. When I click the cell in step 3, the TableTools tab appears so Excel agrees that the cell is in a Table. Isn't Excel supposed to insert a Structured Reference when you click a cell in a Table? Is there another setup/configuration switc...
Outlook 2007 Searching
Each time I do an Outlook 2007 search "Tools/Instant Search/Advanced Find" I have to press the Browse button and check the "Search Subfolders" box. How do I default to always have the "Search Subfolders" checked? Thanks On Mar 7, 9:44 am, "Jeff Roe" <jdru...@hotmail.com> wrote: > Each time I do anOutlook2007 search "Tools/Instant Search/Advanced Find" I > have to press the Browse button and check the "SearchSubfolders" box. > > How do Idefaultto always have the "SearchSubfolders" checked? Jeff, I c...
Deleted contact in Outlook 2007
I have a new Dell laptop with the #$@#$$%$ touchpad. It's been a week and I am still dragging stuff I don't want to drag and selecting stuff I don't want to select. AAARRRRRRGGGGGGG. Anyway, I had a contact open in Outlook 2007 and I did something with the touchpad and the contact disappeared. I don't know if I deleted it, renamed it, hid it, or what. Would I be able to delete it with just one errant touchpad action? Wouldn't it ask me to confirm it? I tried Ctrl-Z but Edit | Undo is greyed out. Will Undo undo a deleted contact? If I didn't delete it, where could i...
Task Manager and unsecapp.exe
When running Task Manager I recently found unsecapp.exe running. I am using XP Pro and have never has Vista on my machine, can I stop this program? It has used 26840K of memory. BillH On 11/25/2009 9:20 AM, Bill T wrote: > When running Task Manager I recently found unsecapp.exe running. > > I am using XP Pro and have never has Vista on my machine, can I stop > this program? Have you tried using Google to search for "unsecapp.exe" to see what you'd find? I just did and the first 4 sites listed were enough to satisfy my curiosity. -- R...
Outlook 2007 cached mode problem
Hi I do some support for a small company that has just installed their first seat of office 2007. They are running SBS 2000. When Outlook 2007 is set in cached mode no emails after February 7th show for the user and no new emails appear. If cached mode in turned off all their emails show. They were running Outlook 2002 on another machine previously which doesn't have cached mode so without trying it on 2003 I can't tell if it is a server or client problem. All other folders appear to be OK. Any suggestions? Has anyone else had this problem? I support this site remotely so exh...
Calculate cost of project against time worked
Hi everyone Have had a good look through various discussion groups for this and can't seem to find what I am looking for, I hope someone can help. I have a access 2000 database which captures projects coming into the department, each project is then resourced to a team member. When they have finished their part they put in how long it has taken them, from 1 hour (up to max of 3hours) then it goes up in 1/2 day increments to 15 days. At the moment I just have a drop downlist allowing them to pick, for example, 1/2 day, 1 day, 1.5 days etc, but now we have a set daily and hourly rate for...
word 97 covert to word 2007
old saved word doc. wont run in word 2003-2007 Files with insert pics okey. Some files will convert but 100 or so will show but not open Have tried many solutions , inc. repair Office Have you tried to repair the *documents* by using Open and Repair in Word 2007? -- Stefan Blom Microsoft Word MVP "2teddy5" wrote: > old saved word doc. wont run in word 2003-2007 > Files with insert pics okey. > Some files will convert but 100 or so will show but not open > Have tried many solutions , inc. repair Office ...
completed task triggers new task
Can you set up the task function in Outlook to create a new task once a "master task" has been completed? What kind of new task? In the form of a recurring task? You can then configure the Recurrence Pattern on the task. -- Robert Sparnaaij [MVP-Outlook] Coauthor, Configuring Microsoft Outlook 2003 http://www.howto-outlook.com/ Outlook FAQ, HowTo, Downloads, Add-Ins and more http://www.msoutlook.info/ Real World Questions, Real World Answers ----- "Sherri" <Sherri@discussions.microsoft.com> wrote in message news:DED33B01-1A25-4181-B062-FD416472C589@microsoft....
Powerpoint 2007 01-14-10
Any chance you know how to REVERSE the order of the bullets (in the old version you could go 10 – 1) ...
Ahead of Schedule task and % complete
If I enter a % complete value on a task that indicates it's ahead of schedule, how do I get MS Project to reflect an earlier finish time than originally expected? Here's a quick scenario: Let's assume I'm on a 2-week project with one task and one resource. Project starts on the first Monday and ends on the 2nd Friday. At the end of the first week, I enter a status date of Saturday into Project Information and a % complete of 80% on the task. Theoretically my project is 3 days ahead of schedule. Is there any way I can get MS Project to reflect that via levelin...
Outlook 2007 appointment durations
Is there any way that we can change the default duration of an appointment from 30 mins to 20 mins. Thanks, -- Michelle "Michelle" <Michelle@discussions.microsoft.com> wrote in message news:B2907478-E063-4EF4-96CA-935F2CC4CA9E@microsoft.com... > Is there any way that we can change the default duration of an appointment > from 30 mins to 20 mins. Set your calendar time scale to ten minutes (right-click an empty area of the calendar, choose Other Settings, and change the Time Scale drop-down), then preselect two time intervals before clicking New. Wi...
Changing default indents for lists (Word 2007)
In previous versions of Word this was relatively easy. I'm pretty adept with Office products, but as far as I can see this is no longer possible. Can someone confirm or enlighten me? I don't like the indents that Word 2007 imposes on bulleted and numbered lists -- it wastes a lt of space and for me is difficult to visually scan. I prefer my first levels of bullets (or numbers) to appear so that the bullet is lined up with the left margin with a hanging indent of 0.25". Then I like the second level of bullets to be at 0.25" with a hanging indent of 0.5", ...
Timesheet and Employee Expenses Approval by Project
I would like to suggest the approval workflow to be by project, right now in project accounting, the employee only can have 2 level of approval, ie, Supervisor and Manager, at most of my client that using Project Accounting, they are requesting the approval to be go by project, ie for the same employee that doing different project, their respective timesheet and employee expenses should route to the supervisor or manger that assigned to the project. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this ...
MS POS 2.0 and Office Account 2007
Has the integration been improved between these two applications since the SBA 2006 and POS 1.x were released? When I looked at it back it didnt do transactions, just batches. I am looking for full integration between the two products. Point of Sale 2.0 ships with Office Accounting 2007 for free. There is a very tight integration where detailed sales, item, customer, vendor, and item receipt information is shared automatically. This site has more info: http://pos.microsoft.com "DomitianX" <DomitianX@discussions.microsoft.com> wrote in message news:C6E30AA5-8D21-431...
Selecting multiple criteria in a report in Acc 2007 using a form
How can I select multiple criteria using a form to generate a report in Access 2007. -- Lady_Dee On Wed, 10 Mar 2010 17:38:04 -0800, Lady_Dee <LadyDee@discussions.microsoft.com> wrote: >How can I select multiple criteria using a form to generate a report in >Access 2007. By putting multiple instances of =[Forms]![NameOfForm]![NameOfControl] or other appropriate expressions on the Criteria line of a query, and use that query as the Recordsource for the report. For a more detailed answer please post a more detailed question. -- John W. Vins...
My Word 2007 Crashed Whenever I Open It 03-14-10
Whenever I open Word or click on a word file, the Word GUI opens and immediately stops responding. The file doesn't load, and none of the buttons can be pressed - I just see a word window without a document and toolbars which can't be pressed. What should I do in order to begin troubleshooting? Thanks. See the article "Problems opening Word” at: http://www.word.mvps.org/FAQs/AppErrors/ProbsOpeningWord.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, ...
Reset of PO, SO sequence numbers
GP 9, SP2, SQL Version. On separate occaisions, our P/O numbering sequence has been reset (to a lower number) as well as the S/O numbering sequence. Has anyone seen this before and know the cause? K It just happened to us last week, too (and has before). I don't know what causes it. "Ken D" wrote: > GP 9, SP2, SQL Version. > > On separate occaisions, our P/O numbering sequence has been reset (to a > lower number) as well as the S/O numbering sequence. > > Has anyone seen this before and know the cause? > > K Ken, For PO's, the only reas...
macro for repeat task and format interior
Hi All, I'm trying to check out repeated value on column Q and the hightlighted entire cell on the left.I put the code that found from Sample,and trying to modified it but I made a mistake.I can't select entire cell on the left, I just can highlight 2 cell ( offset(0.-3) and the cell on column A).Please help how to select entire cell to the left without interupted by blank cell. And also I want to put the copy of higlighted cell value to a new workbook. Thank's. Rgds, Shiro Sub Duplicate_Serial_Number() Dim eX As Integer Dim cell_in_loop As Range eX = ActiveSheet....
Auto Fill function in Excel 2007 not working properly
I cannot get the Auto Fill function to increase values in a series, and I feel certain I'm doing it right: First, I tried typing a series of values in a column like this: Cell A1, I typed 1. Cell B1, I typed 2. Then, I selected both cells with the mouse, and then moved to the lower right corner of Cell B1 and left-clicked and held the mouse button down. Then I dragged the mouse button down several columns. The little pop-up message seemed to indicate that it was repeating 1, 2, 1, 2. When I released the mouse button, it had actually filled a 1 in each cell! After several ...
DPM 2007 SP1 and Windows Server 2008 SP2 Hyper-V Failover Cluster
Should DPM 2007 SP1 be able to backup virtual machines that are in a Windows Server 2008 SP2 Hyper-V fail over cluster? Each VM has a dedicated LUN at this point in time. From previous experience the backups appear to be inconsistent from the stand point of if the machine is migrated to another host the backup breaks. Has anyone successfully implemented backups for this type of environment? DPM 2007 SP1 does officially support backing up VMs on Windows 2008 SP2 Hyper-V Clusters. -- Narendran[MSFT] This posting is provided "AS IS" with no warranties, and confer...
Default Weight in Pivot Table Charts keeps getting reset
Hi, I have created a Pivot Table chart and I am using basic line chart to display the data...I would like to make the line weight 2 points heavier than the standard but each time I select new values from the Pivot Table chart it resets to the default....where do you set this to remain at the values entered... Any help appreciated.... Scott ...
integration of project server 2007 and moss 2007
I have two server in one i have installed single server installation of project server 2007 in which and on the other server separately i installed moss 2007 and make Database server of MOSS 2007 is Project Server 2007. Now we can integrate Project Server 2007 and MOSS 2007 in this way and want to configure proposal workflow. Because i dont want to install moss 2007 in existing installation of project server 2007. I don't know Project Server, but your question is not clear as to what you are asking. -- Daniel A. Galant Imagine what we could be... if we co...
Printing Monthly Calendar (Outlook 2007)
My work has upgraded from Outlook 2003 to Outlook 2007. Every month I print off the monthly view so I can monitor regular events. Outlook 2003 monthly print option only displayed the current month (5 weeks). In Outlook 2007 I am getting a six week view which is compressing the meeting information and displaying some of the next month. Is there a way I can set this so I only get the current month ? -- Malcolm Do you have all the latest updates installed? Outlook 2007 should print exactly 1 month - but there was a bug in early builds and it always did 6 weeks. -- Diane P...
Weird message when opening Word 2007
Since upgrading to Windows 7, I'm getting a strange message when I open Word 2007, which I never got using previous Windows versions. It says: Word could not create the work file. Check the temp environment variable. When I click the OK button, Word opens up and there does not seem to be any problems, but I'd like to get rid of these messages. How can I do that? When Word starts it needs to create a raft of temporary files - some in the working folder, others in the User's temporary folder. The message suggests that Word cannot locate the temporary folder or that it c...
Outlook 2007 won't open
Sometimes I close Outlook 2007 when I'm working during the day and then when I try to open it it won't open. The other MS applications in the 2007 suite open OK all the time. It is only Outlook that does this - maybe 2 or 3 times a day. I have to re-boot to gain access to it again. If, after trying to launch Outlook 2007 I do a restart, the application opens momentarily before Windows logs off and the computer restarts. -- John F XPproSP2 Maybe OL isnt exiting correctly, and as such your Processes Tab will show an instance of Outlook.exe still running (Cntr+Alt+Del > ...