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...Send/Receive at Launch does not work
I cannot get send/receive to work when I launch Outlook
2003. I went to the knowledge base and found "Microsoft
Knowledge Base Article - 312336" and tried it but it
didn't do anything.
Any help on how to get this working?
Anyone have an idea here?
What automatic polling interval did you set?
"Doc" <email@example.com> wrote in message
> I cannot get send/receive to work when I launch Outlook
> 2003. I went to the knowledge base and found "Microsoft
> Knowledge ...Why does copy and paste between eMails not work?
Copy no longer copies to the clipboard. Is there a setting I have deleted
somewhere? Using Windows 7 and Office 2007 proffessional.
Does it work if you restart outlook?
Do you have any addins installed that could be erasing the clipboard? I've
seen this happen with addins and contacts, but not email. to test, open the
new message form before copying so you just need to copy and switch to the
other message. (http://www.slipstick.com/Contacts/clipboard.htm)
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Cent...Outlook and Hotmail -- now works again! For some not all?
Received from MS:
<<Recently, Hotmail� announced that ... Hotmail will no longer
allow new e-mail accounts to be accessed via Microsoft� Office
Outlook� and Outlook Express.
<<We are pleased to inform you that because you are an existing and
valued customer, at this time your current Hotmail and MSN
account(s) are exempt from this restriction and you will be able to
continue enjoying access to those accounts from Outlook or Outlook
Express. However, any new Hotmail or MSN accounts you create will
not be accessible via Outlook or Outlook Express.>>
....an "...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?
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 ...Rule to forward mail to external address doesn't work
It might be an XCON issue but I didn't find the corresponding group so I
post my questions here.
I set up a rule that when an email arrives if my name is in the "to" or "cc"
field then forward the email to another external SMTP address for example an
hotmail address. however this rule never works through.
It's a Exchange 2003 SP1 on Windows 2003 SP1
I have no problem to manually forward the email to that external SMTP
If forward to an mailbox in our Exchange Org, it works;
I turned on diagnostic for Transport, no error or warning logged;
I tracked mes...Need Hyperlink from Menu Page to work in email
I have a workbook with several tabs. First tab is a "menu" type page
(summary of other pages). Currently I have hyperlinks to all the other pages
from the menu page. What I want to be able to do is copy the menu page into
an email and enable the users to click on the existing hyperlinks (whatever
adjustments needed) to go directly to their page of the workbook. Using
Excel 2007. Please advise how to do this and what changes may be need for
both options to work.
...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...Filtering a column to exclude any repeated entries.
I am working on a column that has the same entries 2 or more times. Is there
a way (copy-paste or other) to get only unique entries from this
column (that is to exclude repeated entries)?
Any help apprieciated,
If you go to Data/Filters/Advanced Filters there is a box
at the bottom left that you can tick to return unique
>I am working on a column that has the same entries 2 or
more times. Is there
>a way (copy-paste or other) to get only unique entries
>column (that is to exclude repeated...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.
...Can't Make this Work
I create a new Datasheet form from tlPB and get the "FIRST SQL VIEW".
I then select DirectoryID and from the Row Source, I get the "SECOND
I then select DeptID and from the Row Source, I get the "THIRD SQL
DirectoryID and DeptID are both Combo Boxes.
I want only those DeptID's that are related to the DirectoryID that
has been entered in the Datasheet.
Can someone show me how this is done?
FIRST SQL VIEW
SELECT tblPB.PBID, tblPB.DirectoryID, tblPB.DeptID
FROM t...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 <firstname.lastname@example.org> asked:
| When I download email from a pop3 server, the messages
| are d...Request Responses Not Working Properly
I am running Outlook 2003 sp2. When I send a meeting request out to a
large group of people I uncheck the option to request responses. For
the most part it works except, I continually get one response back out
of the several hundred that I send. The only difference that I can see
between this user and all others is that he is responding back to the
meeting request from his pda, which is connecting via owa. If I
respond directly from owa, it works fine. I tested using another pda
and experienced the same problem. Any ideas?
...Can I use oulook from home and have access at work?
When I set up my outlook I lose all my inbox messages online and would not be
able to read my email from work. Is there a way to have my inbox available on
outlook and remain online?
Just to clarify, are you asking how to set up Outlook at home to receive
email from work? If that's your question, you need to ask your IT Admin or
Exchange Admin if you can use OWA and how that's done. That wouldn't have
email coming into your Outlook account but it is a form of Outlook, Outlook
This may or may not be allowed. Your IT staff would of course have all kinds
of securi...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....Internal emails get bounce backs, external work fine
I have a strange problem. Running Exchange 2003 enterprise service pack 1
One user, can't get emails internally. We get the following message:
Greg Montgomery on 5/9/2006 10:19 AM
The message could not be delivered because the recipient's destination email
system is unknown or invalid. Please check the address and try again, or
contact your system administrator to verify connectivity to the email system
of the recipient.
But externally it works fine. So people emailing Greg using his SMTP
account, all is well.
Here is a kicker though. All of a sudden, some people can now...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" <email@example.com> wrote in message
> how can i find out if LDAP is active on my 2003 server