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...user created shapes non printing
I started have a problem with vision 2002 that I have not noticed
before. When I create a new shape, by default, it assumes the
non-printing properly under FORMAT � BEHAVIOR. Also if I group a set
of "printing" shapes the group will become non-printing. Can I change
How are you creating the new shape? Also are you using layers in your
This posting is provided "AS IS" with no warranties, and confers no rights.
"Robert" <firstname.lastname@example.org> wrote in message
news:9ec427f7.0409231005.576...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...How do I modify an existing worksheet to remove columns & contents
I am working with a very large spreadsheet and want to modify it using only
certain columns and data in order to keep from re-doing the entire worksheet.
ANybody out there in cyberspace got suggestions or good reference sources I
There are just too many scenarios to ponder without getting some more details
on what you wish to do.
Please be a little more specific in your description.
Gord Dibben Excel MVP
On Wed, 9 Feb 2005 18:15:06 -0800, "Gil Gray" <Gil
>I am working with a very large spreadsheet and want to m...Copy field data to multiple places
Newbi here.... I have a access 07 file of about 1000 records (rows) and a
field (column) I'll call the "project number". All the records do not have
the project number inserted as of yet. Is there a simple means to insert a
project number in say 50 records at a time, another project number in
another 75 records etc. Copy/Paste will do it but may take months to enter.
Any suggestions appreciated. TIA
On Wed, 27 Feb 2008 15:31:05 -0500, "Meebers" <email@example.com> wrote:
>Newbi here.... I have a access 07 file of about 1000 records (rows) and ...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...Editing the Subject Line of Incoming Mail
How do you edit the subject line of mail you have received
in Microsoft Outlook Express? I'm using Windows 98 and
Outlook Express 5. I often keep my e-mail -- to respond
later -- but would like to remember what the subject was
of certain e-mails. If the sender did not put a subject,
or if the subject doesn't reflect how I would like to
remember that e-mail, how do I change the subject and keep
it in my inbox?
...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...How to filter to show only one message from a specific sender/subject
I would like to filter out all but one email with the same subject
line from a specific sender.
I subscribe to a message board that sends an email every time a
posting is made to a thread, instead of just the first posting after I
have read the thread. Is there a way for filter out the duplicate
messages and just keep the oldest email?
...OL2003 Cannot Drag Items from one group to another in order to reduce the number of subject groups
In Outlook XP, you could sort according to groups, and then drag items from
one group to another. This was very handy for organizing mail by subject.
For example, (when grouped by subject) two "Groups" of items could be
combined by dragging one group into the other. Subsequently, the subject
line of items in the first group are updated to match the subject line of
items in the second group. The result is one group instead of two. If you
have many subjects, you can dramatically reduce the number of subject groups
by doing this
Unfortunately, this cannot be done in Outlook 2003. Does ...Viewing an Excel sheet w/out all the empty fields...
How do you create a spreadsheet that only shows the fileds with data in them?
-How do you get rid of all the empty rows/columns, to ease viewing for those
who are easily confused by excel spreadsheets?
(I don't know how else to emaplin my question... I just don't want the
extra columns & rows there, if that's possible...)
>I just don't want the extra columns & rows there, if that's possible...
Just hide them!
Suppose the last column in your sheet that contains data is column H. You
can hide columns I:IV so that after column H all you ...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...Problems with german characters (umlaute)
it happes every months that a mail reaches us with I don't know how coded
german characters. Our german customers are calling us, asking what we're
missing on our system.
I've checked one of these mails and the only thing I found out that the
codepage, which was specified in the header, was the same than in the other
mails I've in my mailbox and which I can read perfectly.
The strange thing in current case is, that the email is displayed correctly
when the mail is opened in Outlook Web Access.
I need some help how to get hand on these problems.
Many...Validation Rule for field values
I have a database that includes a phone number field. I want to prevent a user from creating a new record that contains a phone number that is currently in a record that exists in the database.I am using a form for data entry into the table. Somehow I'd like for there to be a check to see if the phone number typed into the phone number field to be checked against existing phone numbers in the database.I've researched various sources but haven't been able to find the solution. I'm not familiar with VB so any replies that suggest using that will probably not work for me. Sorry, j...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...Pivot table fields missing on all computers
I have Excel 2007 installed on two computers. I also have Excel 2010
beta installed on one of the computers.
I am unable to create a pivot table on ANY of them. None will show the
field list. All copies of Excel work fine in all other aspects.
I have searched the net for solutions and found many others have the
same problem but few suggestions to fix it. Many questions never got
any response at all. I did find a reference to try removing the .xlb
file from the XLStart folder. I did, with no results.
I have done all the proper show/hide clicks. I even tried using the
...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?