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...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...Can not install Office Ultimate 2007 because of a setup error mess
I have a desktop with no Office Suite which I built with Windows XP Pro SP2
(Version 2002), from a WGA Kit. I ordered the back-up discs (2 pcs) Office
Ultimate 2007 from digital river.com store and tried installing in this
machine but I get this message: "Setup error: The language of this
installation package is not supported by your system." I tried it on the 2nd
DVD drive of the same machine but same result. I tried installing the Office
software in a Sony Vaio laptop and it seems it will install properly and I
discontinued the setup. Any information/ass...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...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...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...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....Access 2003 and Sharepoint
My company is moving most of our files into Sharepoint -- however, it
seems no one could explain how Sharepoint is going to affect our
current Access database.
Can someone please enlighten me regarding Sharepoint and how it will
benefit us if our Access database is stored in it? Will it make
accessing the database faster through our network? Right-now our
database is stored in a network drive and depending on where we are
located from the server -- it may take long to accesst the data.
Or any sites that will help explain the process of Sharepoint.
You cannot store your A...Script to audit windows 2003 servers
I am looking for a powershell script which we allow me to audit my physical
servers which are in a specific network. Is this possible to do.
The information I need for the server is as following:
- amount of RAM
- amount and speed of CPU's
- local storage
- amount of nics
- amount of HBA
- installed OS
And the subnet the servers are in is 172.16.40.0/21. Is there a way I can
run one script to get all this information. It will of course require
remote access to these servers.
Also the servers are all windows 2003 SP2.
how can i find out if LDAP is active on my 2003 server
LDAP isn't active on Exchange 2003 but only on your DCs.
Try to do a telnet on the port 389 (LDAP).
"Urs Meier" <firstname.lastname@example.org> wrote in message
> how can i find out if LDAP is active on my 2003 server
...ctrl A should select all in MS Excel 2003
In past versions of MS Excel, the keys [ctrl]&[a] used to select an entire
screen. In Excel 2003, pressing it once just selects a table or some
specific set of data. I have to press it twice now to select the entire
screen. It is not a big deal, but I prefer the original way it worked, hence
the name of the fucntion "select ALL". If users would like to select a
subset of data, a different set of keys should be used.
> In past versions of MS Ex...