MS Excel 2003 cannot auto calculate formula, need to press F9 each time
I don't know why my excel 2003 new worksheet cannot auto calulate
formula (eg. summation), i need to press F9 and it will refresh and
show the new figure. there is "calculate" word at the left hand bottom
of the screen.
what is the likely reason ? it was running fine 2 weeks ago.
any advise is greatly appreciated.
Tools>Options>Calculation tab, check Automatic
Microsoft MVP - Excel
<firstname.lastname@example.org> wrote in message news:email@example.com...
| I don't know w...Error during Exchange Backup
I am writing an application to backup and restore M.S. Exchange server
programatically. I am using the Exchange Backup and Restore API and am
developing the application in VC++ 6.0 on a Windows Server 2003 Enterprise
Editioon. I am able to do the backup successfully but I am getting error in
the function "HrESERestoreAddDatabase" during the resore. I am trying to call
the function HrESERestoreComplete as follows:
strTempLocationPath = _T("C:\\viraj\\exchangedata_b...Auto fill and drop down lists
The fields are Rank and Rank Sort (I cant do this alpabetically as a the
ranks (Military) don't run in alphabetical order.
The idea is this:
The form (Pers Details Form) contains personal details Name, Number etc from
the Pers Details Table. There will be box where I can select the rank from a
dropdown list. The Rank details are contained in a seperate table (Rank
Table) containing a Rank and Rank Sort column. In the Pers Details Form I
can create a record, enter details but I want to have a drop down box to
choose the rank from. Once chosen I would like the rank to show (but ...Price list 02-23-06
Does anyone know how to default a quote to a particular price list, or can I
remove this mandatory field? Tks. Ian
Hi Ian, You could write a script at the OnLoad Event of the Quote Form.
var CRM_FORM_TYPE_CREATE = 1;
var CRM_FORM_TYPE_UPDATE = 2;
alert("This is a create form.");
//insert the PriceList GUID into the Price List look up field here.
Hope this helps.
Manisha Powar (Madhusudanan)
Microsoft Dynamics - CRM
This post...Most recommended Exchange book?
I was wondering if you guys could recommend me a good "must have" Exchange
2003 reference book to keep around the office. Something more geared for an
all encompasing and easy to use reference guide than certification testing
would be appropriate. Thanks!
On Mar 13, 8:46 am, Chris Lukowski
> I was wondering if you guys could recommend me a good "must have" Exchange
> 2003 reference book to keep around the office. Something more geared for an
> all encompasing and easy to use reference guide than certificati...Sending email from exchange server to Win2k server on same domain
This has been bugging me, I have a win2K box with smtp installed, I want to
allow users to send messages from exchange to the win2k server where they
will be processed by some scripts.
I have never tried this before and I am not sure of:
1. what is the address of the server (firstname.lastname@example.org?)
2. how should the exchange account/address be configured
Any advice gratefully received
Mark Davey wrote:
> This has been bugging me, I have a win2K box with smtp installed, I want
> allow users to send messages from exchange to the win2k server where they
> will be proc...Outlook 2003
I used to be able to do this in Outlook 2000. The string will be in either
the subject or text body...or both. For example: looking for an email
message about a specific invoice number 12345. Now, it does not find the
number even when I know it's there....and can find it by hunting on my own.
Thanks for any help you can offer~
"Hello_It''''s_Me-CA" <HelloItsMeCA@discussions.microsoft.com> wrote in
>I used to be able to do this in Outlook 2000. The string will be in either
> t...Publisher 2003 Viewer is needed
Can Microsoft create a free viewer program for .pub files like they have for
the other programs in Office?
Can they? Yes
Will they? Unlikely
Larry M. in Illinois wrote:
> Can Microsoft create a free viewer program for .pub files like they have for
> the other programs in Office?
Larry M. in Illinois <Larry M. in Illinois@discussions.microsoft.com>
was very recently heard to utter:
> Can Microsoft create a free viewer program for .pub files like they
> have for the other programs in Office?
Could they? Yes
Is it profitable for them to do so? Probably not.
W...Outlook 2003 #224
When I print from Outlook I get the following screen:
A dialog box opens and says
An error has occurred in the script on this page
Error: Unspecified Error
All other applications work.
...Outlook 2003 hyperlinking error
Have just installed Outlook 2003, when I click on a html
link within an email it opens my default web browser
however the link appears in the browser with these
additional symbols which stop the requested site from
Does anyone know how to fix this problem? Its driving me
...Visio 2003: Custom Toolbars disappear
Sorry for the cross-posting, but I didn't get any responses in the
I recently upgraded to Visio 2003 and have a perplexing problem.
When I create a custom toolbar--or even when I customize a standard
toolbar--they do not appear the next time I load Visio.
Any ideas? I'm getting tired of recreating my custom toolbar every
Go to View/Toolbars/ and you should see the list of customized toolbars you have made at the bottom of the menu. Selecting them will make them appear
I tried to duplicate the problem you are having with seeing a standard ...Automatically redirecting profiles to a new exchange server?
OK old exchange server was SERVEROLD and new one is SERVERNEW (for
The pc has lots of different profiles on it and I dont wanna manually
change each profile to reflect the new server.
Running Outlook 2002 is there a way to automatically do this?
I believe I can use a prf file created using Custom Wizards from the
Office Resource Kit and deploy this to do this for me.
Can anyone give any more detailed info on how this can be done?
<email@example.com> wrote in message
> OK ol...Exchange Router / Deployment Manager
we have two diffrent issues with CRM 3.0. (But i think they belong togehter,
1. In Deployment Manager i can't browse the domain. (all windows are empty)
But i can add users via web interface.
2. On the Exchange -> CRM E-Mail Router -> All users which i have added via
Web GUI generate a "Failure" by locating the CRM Users with the Rule
Thanks for your help!
Have you managed to resolve this issue as we're facing the same problem. Any
help would be gratefully received. Many thanks, Nick.
&g...Moving Email Domain off of Exchange #2
I am in the process of moving one of our clients off of our Exchange
server and on to a third party email host. I have removed there domain
from the default recepient policy, and also disabled and unattached or
deleted their mailboxes. I have repointed there MX record to point to
the new host etc.
The problem is when I try to email them from our network my exchange
server still thinks it is responsible for handling the mail for the
domain and does not try to send it out of the domain. I get a 5.1.1
e-mail account does not exist in this organization.
How do I let Exchange ...Exchange Features Tab in ADUC when using Windows 2000 SP3
I would like to run Active Directory Users and Computers with Exchange 2003
I'm limited to Windows 2000 Prof/SP3
Everything works,except from the Exchange Features tab.
When selecting this tab, ADUC hangs.
Any ideas. (I have to stay on SP3!)
Terminal Services is always my first choice.
On Wed, 13 Apr 2005 23:35:22 +0200, "newsMS" <firstname.lastname@example.org> wrote:
>I would like to run Active Directory Users and Computers with Exchange 2003
>I'm limited to Windows 2000 Prof/SP3
>Everything works,except...Restore messages from Exchange database
Our SBS2000 crashed the other day without a backup of Active Directory.
We now only have a backup of the exchange database (edb and stm
files). The domain has been recreated from fresh and 5 computers were
re-joined the domain. Exchange also were installed. Question: what
would be the right way to restore the messages from the edb and stm
Thank you in advance!
You'll have to recreate the Exchange org and do a restore.
Unless you have a flat file recovery tool like Quest R...Contact file not visible when importing or exporting contacts
I'm tidying up all my contacts files for email and also for my mobile ph
using outlook. Have done this many times without any problems and am familiar
with import export process.
I exported all the contacts to an excel file to work on as it's much easier
than through outlook. Had a hiccup at first as when I got to the select a
contact file to export there was just a blank space. I exited outlook and
went back in and it was all OK.
Now I've finished the excel spreadhsheet and want to reimport it but it's
the same problem in reverse. I can't "see" a co...Update Existing Purchase Orders with New Exchange Rate
I have existing Purchase Orders in Great Plains 8.0 were
some of the line items have been received is there a way
to change the exchange rate for the remaining line items
and any new line items added?
...Works in 2003 but not 2007
When I reference the below function in 2003 I get function displayed... now
in 2007 I get
Any idea what I need to change/set in 2007 so it will run this function?
Function formulaText(x As Range)
'returns the text equivalent of formula in upper left cell in range x
'example: =formulatext(a1) returns the formula found in cell a1 of
'example: =formulatext(a1:b5) returns the formula found in cell a1 of
formulaText = x.Cells(1, 1).Formula
It works fine for me. Are you stored in a stan...List box with available queries question
I have a list box control on a form and want the list box to display all the
queries within the database. The following code is what I have so far but it
does not work. Any help is appreciated.
SELECT [Name] FROM MSysObjects WHERE [TYPE] = 5 and LEFT([Name],1) <> "-"
ORDER BY [Name];
"Billy B" <BillyB@discussions.microsoft.com> wrote in message
>I have a list box control on a form and want the list box to display all
> queries within the database. The following code is what...Publisher 2003 files try to open in Publisher 97 #2
Back again, but with a different Pub 2003/Pub97 issue
Have Office 2003 with Publisher 2003 and Publisher 97 both on my XP Pro system
Recently I find that files created in Pub 2003 are being saved as files with
the Pub 97 Logo, and when you try to open them from the file listing, they
open Pub 97, which correctly posts a box telling me that it cant open the
If I use Publisher 2003 to open the same files from within the application
the work fine.
When I select a 2003 Pub file which contains the Pub 97 icon, the file list
does not contain Publisher 2003, but when I browse and locat...Force command to run for each computer in txt file list of compute
I have a few hundred computers that haven't been defragged in years. I was
wondering if rather than doing it manually, if someone had a script where if
i just put all the computer names in a txt file, it would iterate through the
list and perform a "defrag c: -f" on them all from my workstation. The
workstations all have the same local administrator password, so the process
would be the same for each. I just dont know how to write scripts.
I know if i were going to do this manually from my computer I would run the
command below for each ComputerName
psexec ...Outlook 2003 Personal Address Book forwarding problem
This Outlook 2003 is connected to a Exchange 5.5 Server
The problem is this, everytime I try to forward any e-mail and use any
distribution list on the Personal Address Book it does not want to send the
e-mail but if I try to send it any other way it works fine.
...HTML view with outlook and pocket pc 2003
When I download email from a pop3 server, the messages
are displayed only in text format not in HTML format, i
can't see the images in the email, I only see lines or
Check with microsoft.public.pocketpc for help with PPC.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to the
Swen virus, all e-mails sent to my actual account will be deleted w/out
After searching google.groups.com and finding no answer
Mike Mikhail <email@example.com> asked:
| When I download email from a pop3 server, the messages
| are d...Outlook 2003 Reply Signature
When replying or forwarding an e-mail, the typed text follows the settings I
have set in Tools> Options> Mail Format> Fonts, however the signature picks
up the font from the senders e-mail.
I have edited and saved the signature several times, but for some reason I
cannot get it to provide a fixed font. The style is "Normal" which for my
computer is set to Times New Roman, however, when responding, it converts to
whatever the normal style was in the senders e-mail.
This happens for all mail I respond to, even ones that I originated and were
sent back to me....