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
<email@example.com> wrote in message news:firstname.lastname@example.org...
| I don't know w...Error message needed if incorrect Date Of Birth (DOB) entered
In cell D6 I have a DOB entered....in cell E6 I have a datedif function that
has 3 conditional formatting set as:
1 - If D6 is blank, E6 is blank.
2 - If DOB in D6 is between 18 - 24 then E6 shows age and cell is yellow.
3 - If DOB in D6 is 25 or over then E6 shows age and cell is blue.
What I need is when a DOB is entered in D6 under 16 years old, then D6
returns an error message -" You have Entered an Age under 16 Years - Retry!!
I have tried Data Validation, but cant get a message from tha as I dont know
what to set as the date validation.
I do need a...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...Never Ceasing Error Message in My Mailbox
Account: 'cwjamaicA', Server: 'mail.cwjamaica.com', Protocol: POP3, Server
Response: '.', Port: 110, Secure(SSL): No, Error Number: 0x800CCC18
Hello, I keep getting the message as stated above in Email box. What does
this mean and how can I clear this up. Thanks.
...ALL of my email is gone- getting error message as well
I am getting this message:
The message store has been corrupted by an application external to Windows
Mail. Windows Mail has been able to successfully recover from this
In addition ALL of my emails are gone.
Any suggestions on how I can recover them? And what I should do about the
Try running the various repair functions in
the WMUtil program: http://www.oehelp.com/WMUtil
If still no improvement, upgrade to Windows Live Mail:
It will automatically import all your WM data.
Gary VanderMolen, Microsoft MVP (Mai...No clipart on microsoft site
When I tried accessing the clipart on Microsoft's site, no results ever come
up. Why is this? The photos come out, but it doesn't show any clipart.
You are supposed to click on that little box below those pictures and then
click on download.
MVP Microsoft [Publisher]
"Jo Dude" <email@example.com> wrote in message
> When I tried accessing the clipart on Microsoft's site, no results ever
> come up. Why is this? The photos come out, but it doesn't show any
> ...Errors 0xC00CE553 and 0x800CCC32
If I may request your assistance again:
I keep getting this error message 0x800CCC32 in a random mode and with
diverse reasons, such as "Not Authorized", "Verify user and password", "Bad
password", "Incorrect user or password" etc.
Now I am also getting a 0xC00CE553 error.
This happened usually randomly, in regard to 5 MSN and 3 Legacy Hotmail
accounts I have, when downloading the messages. Most times it does not
occur. Yet and in spite of the error, the messages download anyway.
I have implemented placing msn.com and hotmail.com into the Privacy tab o...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...Send and Receive All Error Message
When Sending and Receiving before going offline with
Outlook XP,(exchange 2000) I get the following error...
Task 'Microsoft Exchange Server' reported error
(0x8004010F) : 'The operation failed. An object could not
...Outlook 2000 error msg.
I am running XP on a Dell 8200. I've been using Outlook
2000 for a long time now and all of the sudden I get the
following msg: unable to open default e-mail folder.
C:\Documents and Settings\tdiehl\application
I have inserted MO-2000 CD and tried to repair and
removed the program completely from machine and
reinstalled. NO luck. Any ideas???
How big is your pst file?
"Ted D." <firstname.lastname@example.org> wrote in message
> I am running XP on a Dell 8200. I've been using Outlook...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 ...reported error (0x80070057)
When I try to send an email to several addresses using Outlook 2003, I get
Task 'xxx - Sending' reported error (0x80070057) : 'Could not complete the
operation. One or more parameter values are not valid.'
I see no apparent problem with the addresses. Please tell me in simple
English (well, as simple as possible) how to solve this problem. I am not an
What type of mail account is this? Exchange, POP3, IMAP?
"lemonscented" <email@example.com> wrote in message
news:EC994AB1-B72B-4...Createing Quote sometimes make Error: 80070057
Today I found some funny problems.
I create Quotes via the quote WebService from the CRM.
This normally works fine, but now I have some quotes, which will get me an
error, when I open it. This error is no normal error, I will get an
white/yellow Page with ASPX Errorpage:
Here the Message (sorry but I only have this error in German):
Serverfehler in der Anwendung '/'.
Beschreibung: Beim Ausf�hren der aktuellen Webanforderung ist ein
unverarbeiteter Fehler aufgetret...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...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...Compile Error in hidden module: Autoexec #2
I need help when ever I opepen or close any office
product ( excel , word etc...) I get the message shown
above.... How do I fix it please help
Take a look at this:
"Ash" <firstname.lastname@example.org> skrev i meddelandet
> I need help when ever I opepen or close any office
> product ( excel , word etc...) I get the message shown
> above.... How do I fix it please help
...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...FRx
I encountered problem of changing default base period.
The version of FRx software is 6.5.28 and it is running under Windows
The situation was:
After opened the Catalog of Report Window, there was a pop-up message
box which said 'Changed the default base period to C'. I did not know
why this could happen.
- Would you please tell me under what circumstances this pop-up message
box would display??
In order to continue to use this software, I only could click 'OK' from
the message box. The report date is then changed to 'Default Base
Period' - (Ja...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.
...OWA slow performance via a Citrix Desktop ....
We have Users who access their mail via Outlook Web Access from an IE
Browser sitting within an ICA Published Desktop.
The performance seems variable to say the least.
>From what I can see nothing gets loading to the Users Citrix Profile
Using OWA via a normal PC Desktop works fine performance wise.
Any suggestions on how to improve the performance of OWA when using it
through a Citrix Published Desktop.?
Many thanks in advance ....
Have you tried adding OWA to the Trusted Site list on the Zones page for
Internet Explorer on your Citrix Servers?
I'm try...Run-time error '380'
Back in 2003 I created a macro for a form that was working fine. I haven't
used it since but now that I need it, I get all these strange errors that I
am sure where not there back in 2003 (e.g. I had to in include VBA in the
txtBirth.Value = VBA.Format(spnBirth.Value, "d-mmm-yyyy")
Now my problem is with the code:
spnDOE.Value = Date
when I get a run-time error 380 that it could not set the value property.
Invalid property value.
...multiple instances of IE on same site
I have winxp and use IE 8. My problem is that I have 2 usernames on some web
forums. I used to be able to login using both usernames and have both
instances running simultaneously. Now I can't. Everytime I'm logged in and
try to initiate another instance the username just changes. It does not allow
me to open 2 IEs with 2 usernames at the same time. I'm pretty sure this is
just a setting but I don't know where it is. The reason I think it's an IE
setting is that when I try to login with a competitor browser as the 2nd
user...it allows it. Any help would be gre...