Reply:

Trying to understand reference cells
Lets say cell A1 is the fixed value I want to reference . B2, C2, D2, & E2 are all different factors (costs & quantities) in an equation, and F2 which also references A1 is the final result. I'll develop several scenerios in new rows, 3, 4, 5, 6, 7 & 8. When I click, hold & drag F2 down to F8, the reference to A1 changes. How do I keep A1 referenced as I drag? I'm searching the KB as well as this group, but I'm not sure how phrase my question... Thanks, David... Hi David click on A1 in your formula and press the F4 key, this will turn the cell reference ...

OutlookXP keeps trying to send 'delivery reciept' to email account and fails
Hi, I am having problems 'sending and receiving' from Outolook XP. I keep getting the error "Sending and Receiving' reported error (0x80042109)". Looking up this error I understand that Outlook is trying to send a 'delivery reciept' for an email I received from someone. I had selected OK without noticing that the email came from my "Yahoo" email account. I cannot send email through my Yahoo email account from Outlook since Yahoo does not allow it (or I have not figured out how to set up). Now Outlook keeps trying to send out the 'delivery reciept&#...

Outlook trying to connect to strange server
I'm using Outlook 2003 running under XP home. Every time Outlook starts, my virus checker (Kaspersky) reports "The application C:\Program Files\Microsoft Office\OFFICE11\OUTLOOK.EXE cannot establish connection with server 66.151.189.37. Please check your internet connection settings. If you have a firewall installed, check that the application avp.exe is allowed internet access" Well, avp.exe is the virus executable and it has internet access. the ip quoted is registered at colospace.com. I have scanned for Trojans and adware without finding anything. Anyone any idea what...

Online update fails
Hi, I have several Bank of America accounts. I was able to get the accounts to update online but for the past month or so online update fails and no inclination as to what went wrong is given. All accounts (checking, saving, etc) fail to update. I called Bank of America customer support to learn that they don't support Money. Can someone tell me how I can troubleshoot this? If you look at the commnets made in other threads you will find that the Bank of America automatic download from Money 2005 is at best very problematic. Money 2005 has introduced a second method for downloads fr...

Can't locate updates for Excel X for Mac
Operating System: Mac OS X 10.5 (Leopard) Processor: Intel I've got Office X for Mac. When I go to <a href="http://www.microsoft.com/mac/">http://www.microsoft.com/mac/</a> which some suggests as location to get updates, I find no links or info for Office X for Mac, only choices are Office 2004 or Office 2008. <br> How can I determine if I have the latest updates for my Office X for Mac? <br> (My current Excel shows version 10.1.9) Hi, Office v.X is no longer supported, which is why you can't find any updates on Mactopia. The 10.1.9 updat...

[ANN] Apple Security Update blocks Microsoft's update process
Microsoft updaters include a step to safeguard users that have not followed directions to quit all applications before updating. However this safeguard is now blocked by a recent Apple security update. This affects Leopard users only! Read the full story here.... Apple Security Update blocks Microsoft's update process (The Entourage Help Blog) <http://blog.entourage.mvps.org/2008/08/apple_security_update_blocks_microso fts_update_process.html> In case the above link does not work: <http://ub0.cc/79/3> -- Diane Ross, Microsoft Mac MVP Entourage Help Page <http://www....

Combobox not displaying data with after update function
I have a combo box in an ADP database with an After Update function as follows: Private Sub PartNumberTestcbx_AfterUpdate() Forms![AMC_PartNumberTests].RecordSource = "SELECT AMC_PartNumberTests.* FROM AMC_PartNumberTests WHERE PartNumberID = '" & [PartNumberTestcbx] & "'" Forms!AMC_PartNumberTests.Requery DoCmd.GoToRecord , , acLast Detail.Visible = True End Sub All works but the problem is that the combo box does not display the value selected at times. It is blank, but if you put the cursor in it, it displays it. Does any one know how to correct thi...

Updating task list in calendar view
I have just recently begun using Outlook, so please forgive the newbie question. Whenever I get a daily calendar view with the task pane on the right, the task list includes all tasks, current and future. I can configure the Outlook Today window to just current tasks and I know that there has to be a way to do the same thing with the calendar view. Can someone point me in the right direction? Thanks, Charles right click on the task list and change the view. -- Diane Poremsky [MVP - Outlook] Author, Teach Yourself Outlook 2003 in 24 Hours Coauthor, OneNote 2003 for Windows (Visual...

Blue Screen: A thread tried to release a resource it Did Not Own in function CreateFileMapping called
Hi I am my driver virtual filesystem. When I open a file from the virtual drive filesystem is ok for reading file. By cons when I have a blue screen when i call the CreateFileMapping on my handle file opened on my virtual drive filesystem. NTSTATUS DrvDispatch ( IN PDEVICE_OBJECT DeviceObject, IN PIRP Irp ) { PIO_STACK_LOCATION irps; NTSTATUS status=STATUS_NOT_IMPLEMENTED; KdPrintf(("[VFUM] control\n")); irps = IoGetCurrentIrpStackLocation(Irp); if (irps!=NULL) { KdPrintf(("[VFUM] vfums_control : Device:%x Majorfunction %d ir...

How to update sent items on IMAP Folder on server using Outlook 2003 ?
How to update sent items on IMAP Folder on server using Outlook 2003 ? My Inbox is updating but my sent items on IMAP Server are not updating, any idea please ? My Root Folder Path in IMAP E-Mail Settings is Blank. Best Regards, Luqman ...

After 12.2.4 update, cannot open some Word docs with Open passwords
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel After installing the 12.2.4 Office update, I am unable to open some Word files that I had password-protected with an Open File password. How can I open? Thanks Basically, "you can't". Sorry, the other passwords are crackable, but "Password to Open" is effectively the encryption key. The entire file is encrypted, and unless you have the correct password, you can't get it open. However, are you sure you are not attempting to open files that were password-=protected on the PC? ...

Exchange Calendar update tool = unable to find mailbox timezone:Error 0x80004005
When i run the exchange calendar update tool i rececive the following message "Unable find mailbox timezone:Error 0x80004005". I have given my user account full permissions to each exchange store. What else could be causing this problem? alos how do i grant exchange view only admin, exchange full admin, and send as rights to my user account manullay. This script is not working for me? thanks "Jef A" <jef.aldrich@tatumllc.com> wrote in message news:%23AssN4YYHHA.4008@TK2MSFTNGP05.phx.gbl... > When i run the exchange calendar update tool i rececive the follow...

download [Optional Hardware Updates] as a file for later
Is there a way to download [Optional Hardware Updates] as a for later installation? Normally updates can be downloaded as a file for later installation (or for distribution to other machines or for installing over a network), but I don't appear to be able to do the same for [Optional Hardware Updates]. Any help will be appreciated. Please advise. Thanks, Tracey Hello Tracey, What hardware ? Do *not* get hardware updates from the Windows/Microsoft updates web page unless your hardware happens to be Microsoft manufacturered... Always get the hardware drivers (when you...

Timed automatic update of chart
Hi, I am having great difficulty in doing the following and would be grateful for any assistance. Cell A1 is updated every few seconds using a DDE link. I would like to create a chart within the same workbook that plots whatever is in A1 Sheet 1 every 5 or ten minutes throughout the day. Any advice? Thanks Andy ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ ...

Will US software function/update correctly on UK Apple Mac
If I was to purchase a US edition/version of Office 2004 for Mac (or any other major software, e.g. FileMaker Pro) from a US online supplier will it work on a UK spec Powerbook? Frank ------------------------ Please reply only to the newsgroup in article 39eb6716.0410072253.404d8033@posting.google.com, Francis J. Smith at fjsmith@hotmail.com wrote on 8/10/04 8:53: > If I was to purchase a US edition/version of Office 2004 for Mac (or > any other major software, e.g. FileMaker Pro) from a US online > supplier will it work on a UK spec Powerbook? > > Frank > > --------...

Office 2004 update disaster!
Hi! I have automatic updates for MS Office enabled on my computer, and I returned from work yesterday to find that I can no longer open my Entourage (error I/O) after said update took place! When I try to open my mail, the MS utility app pops up and asks if I want to try verifying, rebuilding, compacting database, but after a few secs gives me same error message. Is there any way for me to uninstall that update? I also get an error message after I open up Word, PowerPoint, Excel about the frameworks (or something like that) library. In article <1168540291.912880.54920@p59g2000hsd.googlegr...

How to update "Custom Priority" or "Custom Status" Task fields?
I'm trying to enhance how I organize my Outlook tasks, and I see two custom fields are available; "Custom Priority" and "Custom Status" but I cannot update either field nor is there any content in Help about either of these fields. Has anyone used these fields? If so, please share. Those are not standard fields for Outlook tasks. That's why you'll find nothing in Help about them. Some other source -- an add-in or the user -- added them. -- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users ...

How do I update a catalog which I created with Merge template
I have created a Catalog and used the catalog merge wizard to import all fields from a comma delimited text file. All data was successfully imported. However, I am ready to update the catalog now and have added rows to the text file for new entries in the catalog. When I open the catalog publication it does state that "Opening this publication will access data from location xxxx. Data from this location will be inserted into this publication where others can read it". However, none of the new (or changed) data is imported. What am I doing wrong? Did you convert the mer...

MSM 2004 Premium
Hello, I wonder if anyone has any ideas on this one? I track a number of publicly traded investments on MS Money 2002 Premium. Of all of them, only one has trouble getting price updates. Ticker CSMVX gets a price update maybe one time in 10 that I do an update. 90% of the time it gets no information and so that day's portfolio totals are done assuming a zero value. On days that matters, I have to go in and manually enter the price I get elsewhere. Interestingly, the chart in MSN Money/CNBC - http://moneycentral.msn.com/investor/charts/charting.asp?symbol=CSMVX - shows zeros...

Exchange 2003 messages hanging in que while trying to forward
I am working with a client who is splitting into 2 companies. Their IT guy has setup forwarding to my SBS 2003 Standard box. The addresses are: My address is corp.xyz.com His is xyz.com 9 accounts that are now at corp.xyz.com will receive forwarded email from their old acct of xyz.com. The problem on his end is that messages that are supposed to forward are hanging in the que. He rebooted once and it sent the messages. Any new messages are now hanging in the que again. Any ideas? Thanks!! John The reason they'd be sitting in the queue would be that it can't talk to your...

i am trying to format a cell with the oz (ounce) symbol
i need to format cells with weight, similar like one can format with currency. is there such a thing. Try custom format: # "oz." Micky "Nabil" wrote: > i need to format cells with weight, similar like one can format with > currency. is there such a thing. Hi, You can apply a custom format of #" oz" or "oz "# or "Ounces "# Mike "Nabil" wrote: > i need to format cells with weight, similar like one can format with > currency. is there such a thing. Just in case you don’t know ho...

Rollup 1 Error: De versie van de update komt niet overeen met de geinstalleerde versie van Microsoft CRM
Hello, 1. The clean installed CRM Server (Dutch Language) is patched with the Rollup 1. Build revision in the DB is 2321 2. A fresh dutch Outlook client is installed on XP-client. 3. Rollup Update 1 NL on the client gives popup error in Dutch as stated in the subject. Translated it says something like "Version mismatch between the update and the installed version of Microsoft CRM" ...

For those with IMF update problems
Just thought I would mention that you must use "Microsoft Update", not "Windows Update" in order to get the latest updates for IMF. Hope this helps some people out. -- Eddy - MCSE Hi Eddy, Thanks for your posting and especially appreciate the information that you shared. We value your presence here and look forward to working with you again in the SBS newsgroups! Here I just want to provide some related information for your reference: How to update the Intelligent Message Filter version 2 in Exchange Server 2003 SP2 http://support.microsoft.com/?kbid=907747 Hop...

Update
What is Happening? This message is to inform you that Microsoft will soon begin discontinuing newsgroups and transitioning users to Microsoft forums. Why? As you may know, newsgroups have existed for many years now; however, the traffic in the Microsoft newsgroups has been steadily decreasing for the past several years while customers and participants are increasingly finding solutions in the forums on Microsoft properties and third party sites. This move will unify the customer experience, centralize content, make it easier for active contributors to retain their influence, mitiga...

Alphabetical list of Numbers are not correct!
I'm working with numbers in a column and some numbers are the same. when I try to have the numbers accend in numeric order they are arranged wrong.. 26125 then 26126 then 26125 again. 506 will come before 0506. I want the numbers to line up like 0506,26125, 26125, 26126, 506. letter are no problem just the numbers. Any help would be greatly appreciated! Hi Scott the only way i can get the "numbers" to behave like you want them to is to enter them with a leading ' e.g. '0506 '26125 etc the ' doesn't show, but when i use data / sort to sort them they so...