2 Questions on Pivot Tables
Any assistance appriciated. (Excel 2003)1) I have a simple Pivot table showing 6 groups with their totals and a subtotal eg: America 10 UK 15 Oz 22 etc. Grand Total 125I want to Pivot Graph this data, no problems. I want however an extra line to show the total on the Secondary Axis. I have almost got it by placing the column in a second time as a Running Total and then as a Line on my chart, hiding all the values until the last point.However I would like if possible the Total as a horizontal line across the chart?2) I h...
Any word on CRM 1.2 release date?
Has anyone heard a firm release date yet for CRM version 1.2? And will CRM 1.2 work with SBS2003 that was just released?-kw'Jim' <jim@nospam.com> wrote in messagenews:ehxGoPvnDHA.644@TK2MSFTNGP11.phx.gbl...> Has anyone heard a firm release date yet for CRM version 1.2?>> This depends on where you are based. I've just got home from an MS course, and we told that in Australia it will release to the partners at the conference late next month, and will be released to customers on 12/1/04.It was also confirmed that it will run on SBS2003 - it will ru...
Page set up #2
I want to use the paper size of A3, but cannot find it in the paper options. Anyone know where I can find it? Check your printer properties and preferences. If the printers you have installed won't handle A3 you won't have it. And you will need to 'install' something that will. Even a 'PDF' file printer will do.Alan Badgery wrote:> I want to use the paper size of A3, but cannot find it in the paper > options. Anyone know where I can find it? I've just a home use computer, but the intention was to use the work book between and home and work, w...
Monitoring Exchange 2003 #2
Hello,We are planning to implement MOM 2005.However, we are also concerned about implementing auditing for changesmade within ESM.Will there be a tool that will allow management to know a change was completed by a specific UserID? When a mailbox store is dismounted - who dismounted it/date/time?When a change is made to the RUS - who made the change?Thank you,Exchange2003 MOM does not have the ability to monitor this in the shipped Management Pack.You can enable AD auditing on the domain controllers: http://support.microsoft.com/default.aspx?scid=kb;en-us;314955&sd=tech. ...
smtp addresses #2
Exchange 2000.I have 2 smtp addresses under recipient policy.smtp: username@domain.com (set as default)smtp: username@local.domain.comThese were created automatically when we migrated from exchange 5.5 to 2000.local.domain.com is our internal domain.domain.com is our Internet address.I unchecked local.domain.com address, and 'Apply this policy now', but itdid not remove them from each users AD account.So I deleted the local.domain.com address, and 'Apply this policy now', butit still did not remove them from each users AD account.We are getting NDR's b...
Business Office Equipment and Partnerships
Hello everyone,I m running a home business and found that there was no category to place my startup business expenses for my sole use business software like Microsoft Money and my new printer. Is there a category in which I can keep track of these expenses in which it will show up as a business asset in which I can depreciate later? Also, was wondering for tax purposes, how should I set up Money to keep track of my roommate/business partner's financial stuations? ...
Exporting emails from Outlook 2003 #2
I have a folder that contains over 500 threads on technical matters on a subject.I have tried to use Export to Exel but this does not transfere all the information over including not giving all the text in the body of the email.A similar problem is saving an email to a folder outside outlook it doesn't show the date so you may have a huge list of items all titled but not dated in the titlePlease can anybody help? Hi stevtbwhy do you want to export the emails. What is the target/reson to export the emails?--Oliver VukovicsShare Outlook without Exchange (Vista Ready): Publi...
2008 Upgrade
Can Windows Server 2003 SP1 (32/64-bit) be in-place upgraded to Windows Server 2008/2008R2? or is Windows Server 2003 R2 SP2 a minimum requirement for upgrading. Can we upgrade Windows Server 2003 SP2 to 2008/2008r2? Hello Venkat, SP2 isn't a requirement but you should always have the latest SP and patches installed. Also you can NOT inplace upgrade to Windows servre 2008 R2 as this is only available in 64bit OS. 32bit OS cannot be in-place upgraded to 64bit OS. Additional i prefer a fresh install especially when the OS architecture has a major change as from Wi...
I want to buy the best book of office 2003
Hi.I want to buy the best book of office 2003, what is the name of it?Marco Hi, Marco.> I want to buy the best book of office 2003, what is the name of it?'The Best Book of Office 2003.' (Just kidding!)'Best' is subjective. Check out former Access MVP Jeff Conrad's lists of recommended books and find the ones for Access 2003, then go to your bookstore and look at each one to see if it's 'for you' -- and your learning style.http://www.accessmvp.com/JConrad/accessjunkie/resources.html#BooksNotice that these books are all Access databas...
where do office 2000 (including excel of course) service packs go
where do office 2000 (including excel of course) service packs go. I don't know why they don't give you the option of downloading and saving them before installing the various program updates and service packs. This way whenever I do a fresh reformat of my computer, i need to spend hours getting all the updates again off of the internet, where as if I could save thme, I would just have to re-install. Any help would be appreciated Don't know about Office 2000......never used it, but Office Download centeroffers you the choice of installing or saving to install file to disk....
training #2
Is there a class offered on Publisher and if so will it ever come to Ohio? Thanks Lots of good training articles available on the Office site.http://office.microsoft.com/en-us/training/CR061832741033.aspxWhere in Ohio?-- Mary Sauer MS MVPhttp://office.microsoft.com/http://msauer.mvps.org/news://msnews.microsoft.com'Cindy Taylor' <anonymous@discussions.microsoft.com> wrote in message news:0ed301c4f293$82579a30$a501280a@phx.gbl...> Is there a class offered on Publisher and if so will it> ever come to Ohio? Thanks On Tue, 4 Jan 2005 19:06:21 -0500, '...
Microsoft 60 Day Trial Key
Hi I have a new HP PC with Office 2007 Trial installed on it with an Activation Assistant that I click the 1 button to get a 60 Trial key. When clicking this I don't get a key but pop up message. 'The Microsoft Office Activation Assistant was unable to request your trial activation key. Please check your Internet connection and try again. If the error continues, go to www.microsoft.com/office/pctrial2007 to request a trial activation key. ' So i then goto website and click on the link which takes me to here: http://office.microsoft.com/en-au/products/FX101759...
Event ID c0072030 #2
We have an Active Directory Organizational that contain all of our contacts. I have run the delegation of control wizard and given a user full control over the contacts OU. When I log on with that users account and try to update to add an SMTP address to a contact I receive the following error: There is no such object on the server Facility:Win32...
Outlook not opening #2
I recently installed Outlook. When I try to open it, I get the error message 'Outlook requires Outlook Express 4.01 or greater'. I do have OE 5.0 installed. Why am I getting this error?...
List Boxes #2
Can someone tell me how to correct the following code so that bothcolumns in the listbox will be updated? Only the first columndistplaysDim MyArray()ReDim MyArray(mycount, 1)usrGLDist.lstOutput.ColumnCount = 2 For i = 0 To rst.Count - 1 MyArray(i, 0) = rst.Value('descr') MyArray(i, 1) = rst.Value('pcamt') rst.MoveNext Next i 'Load ListBox1 usrGLDist.lstOutput.List() = MyArray Richard wrote :> Can someone tell me how to correct the following code so that both> columns in the listbox will be updated? Only the first col...
How can I line up 2 columns with similar information?
I have 2 columns with names in each and I'd like to line them up next to each other. I think we'll need more information, Kathy. I don't understand what you're trying to do. Can you give exactly what's up?************Anne Troywww.OfficeArticles.com'Kathy' <Kathy@discussions.microsoft.com> wrote in message news:A5C0BC96-7E27-4C55-89A3-03513FC0D409@microsoft.com...>I have 2 columns with names in each and I'd like to line them up next to >each> other. Column A has employee number, Column B has the same employee numbers but has addi...
Lost Product Key #2
Wanted to install my publisher deluxe 2002 onto my new computer. I've lost my product key. What can I do? How do I do it? Whistle Britches wrote:> Wanted to install my publisher deluxe 2002 onto my new> computer. I've lost my product key. What can I do? How do> I do it?Have a look at the following KB article:(823570) How to Obtain a New Product Keyfor Office Program Setuphttp://support.microsoft.com/?kbid=823570-- John Inzerreturn e-mail disabled...
RMS POS 2.0 SP1 fails to install
We are running RMS 2.0, and when I tried to install POS SP1 I get the following error' The expected version of the product was not found on your system' I have searched kb and found nothing that may address this. Any ideas would be appreciated.Thanks Sounds like you got the wrong service pack. POS is a different product. You need RMS 2.0 Service Pack 1.Marc'Davidjc52' <Davidjc52@discussions.microsoft.com> wrote in message news:EE74C3F9-0CF6-4693-889C-8CD301CA691F@microsoft.com...> We are running RMS 2.0, and when I tried to install POS SP1 I get the&g...
How do I make a particular column required in Excel? #2
Our NPO is creating a reimbursement chart in Excel. We're trying to make it so that if employees do not fill in one particular column entitled 'Projects,' they will get an error or will be unable to have a final sum filled in.Is there any way I can make this particular column required so that if it is not filled in, the chart will not complete properly?Thank you in advance for any advice or help--I'm a bit of a novice to this!...
help with lookup formula (sheet 2, not a double post)
I need to make a formula using a lookup. The first spreadsheet is ainventory (ALO INVENTORY JP). The second (P&G 103) is a chart thatells number of gallons of alcohol per foot/inch/fraction. On ALO INVENTORY JP I insert the # of feet, inches, and the fraction icells R5 and T5. I want these numbers to lookup the number of gallonoff of the P&G 103 worksheet. For example: P&G 103 (on inventory sheet) is 26ft 4 1/2 inches, ishould look-up to be 34572 gal. for the 26'4' and 55 gal. for the 1/2'These two numbers should be added together and multiplied by the numbe...
Reporting Bugs to Microsoft
I have found a bug in Exchange 2003, does anyone know how I report this? Whats the bug?-- Mark FugattMicrosoft Exchange MVPwww.exchangetrainer.comwww.msexchange.org'fatiefats' <anonymous@discussions.microsoft.com> wrote in message news:682EE703-4471-4D68-9359-CD32DD34DA9D@microsoft.com...>I have found a bug in Exchange 2003, does anyone know how I report this? I attempted to uninstall Exchange server. I need to do this because the domain controller was incorrectly installed. Anyway I am getting this message:Setup encountered an error while checking prereq...
Microsoft Word
I have created a new Microsoft Word Form and would like to insert at the bottom a simple button or link the user can press when the form has been completed which will automatically insert the completed form into an email(as an attachment) ready to be sent. How can I accomplish this? Thanks in advance. -- KPFDCO3 ------------------------------------------------------------------------ KPFDCO3's Profile: http://forums.techarena.in/members/222188.htm View this thread: http://forums.techarena.in/ms-office-support/1338781.htm http://forums.techarena.in ...
Money 2006 to 2008
I got the dreaded notice that I needed to update so that I couldcontinue my services. Was running 2006. No problems. Upgraded toMoney Plus 2008. I really am using just the basic features for now.It takes *forever* to open. Once I do an online update and itcompletes, it takes about twice or three times as long to returncontrol to me as 2006 did.Any way to speed it up? I'm running Vista on a not too ancient dualcore 2.2 GHz with 4 GB RAM. In microsoft.public.money, Grouch wrote:>I got the dreaded notice that I needed to update so that I could>continue my services....
I need a list of command line switches for Microsoft WORD.
I am using a Shell command to execute Microsoft WORD 2003. I need to halt execution of VBA code until WORD finishes it's task. Is there a command line switch for WORD to cause it to pause the VBA function until it is finished? Is there a VBA command to pause execution of code until WORD finishes? Thanks. I am pretty sure the answer to your specific question is 'No'. If you tell us exactly what you are doing, including from where the Shell command is being executed, maybe we can suggest another way that will overcome the problem. -- Hope this helps. Please r...
Need help converting Microsoft Outlook calendar to Entourage.... At wits' end here! Please advise...
I have a Mac at work which runs Microsoft Outlook 2001 client on an Exchangeserver. I have a calendar on this machine (stored locally, not on theserver) which has a ton of reminders programmed into it - very useful! Now,at home I got a new Mac laptop with Entourage X. Is there any way to moveall of the reminders (appointments) from my calendar on Outlook to myEntourage calendar? I've tried two things:1) I exported the calendar info as a CSV text file, and then tried importingit in Entourage. The problem is that Entourage import function seems tothink it's importing an Address...