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...Can't track certain Outlook Contacts
For one of my users (crm 3.0 - Outlook 2003), the 'Track in CRM'
button does not appear for certain contacts. About 2/3s of the
contacts are fine. I thought it might be contacts created in the
Blackberry then sync'd to Outlook but that doesn't appear to be the
I'm still working on finding a pattern, unfortunately this user is
travelling a lot so it's hard for me to sit down with her and see what
I thought maybe someone may have had a similar experience.
...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 ...Can't Make Attachment
I just upgraded to outlook 2003 and now I can't drag and drop files into a
new mail message; even though I can click on the paper click and attach a
file that way. I had this functionality prior to upgrading to Outlook 2003. I
am running Windows XP. Please advise if anyone knows of a setting for this or
a registry fix.
...How can I ...
I am now running Outlook 2003. Previously, I have run most versions of
Outlook and I have spotted a difference I would rather not have.
Whenever I click on a web link within a message, outlook opens a new
instance of IE to view whatever is on the end of the link. Previous versions
would re-use the first instance created rather than opening new instances
all the time.
Any suggestions as how whether (and how?) this behaviour can be restored to
match the previous versions?
You can't. Sorry.
Author, Special Edition Using...Removing Message Handler
I am using Microsoft Visual C++ on Windows XP and am developing
Windows graphics code using the MFC AppWizard. I have a class,
CImageView, which is derived from CScrollView.
I would like to add a message handler for WM_LBUTTONDOWN but, when I
got go "Add Windows Message Handler", this is already in the list of
added handlers. When I highlight it and click "Edit Existing" I am
taken to OnMouseMove(). There does not appear to be a way to remove
this handler so that I can add it properly. It is possible that I
added it at some point and then rmoved it by deleting every re...Where Can I Find The Icon For A New E-mail Message In Outlook?
I've created the shortcut "C:\Program Files\Microsoft
Office\OFFICE11\OUTLOOK.EXE" /c ipm.note for my Outlook to open a new
message but it assigns the Outlook Icon...
Assuming you are using an English version Outlook 2003, you might find what
you are looking for at:
\Program Files\Microsoft Office\OFFICE11\FORMS\1033
"Justern" <email@example.com> wrote in message
> I've created the shortcut "C:\Program Files\Microsoft
> Office\OFFICE11\OUTLOOK.EXE" /c ipm.note for m...Can I see the summary report of each resouce's booking status ?
Here we using AutoAcceptAgent to booking resource account like meeting room.
Is there any method to view the summary report ? for example, a summary
report show which meeting room booked by which one for what agenda. I have
tried to use public folder with email address, but can't register by
AutoAcceptAgent. Any one has any idea of such request ? Pls help soon. Thanks.
On Thu, 20 Jul 2006 19:14:02 -0700, Enid
>Here we using AutoAcceptAgent to booking resource account like meeting room.
>Is there any method to view the summary repor...last 4 wk average using calculated pivotitem
I am trying to create a pivot table/chart from data that is listed b
week. So my table has "week" as the row field and "total X" as th
column field. I want the chart to display the total for each week as
bar (the easy part) and also to graph the average of the last fou
weeks as a line on top of the bar graph. I have tried to figure ou
how to add a calculated pivot item but I can't seem to get it to wor
right. So for each week there would be a second almost subtotal lik
entry that calculates the average for the previous four weeks (if ther
aren't four previo...SQL Back-end / Access Front-end using linked tables????
I have a backend that contains tables that I pull Driver information,
Customer information , etc. (these are MAS 200 accounting software
tables that are exported nightly to the SQL backend). I also have on
the backend tables that I push information to; information that we
enter on the forms located on the front end. I might not have this
up correctly, but I'm linking all tables on the back end to the
database on the front end. When trying to set up an Auto Lookup off
a query I've created in Access it says I need to go into the table
change Data Type to the Lookup wizard,...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...Where can I get UNLIMITED Excel stock qoutes?
The Excel Add-in that allows you to retrieve stock qoutes is limited in taht
it only allows you to get about 250 qoutes at a time. How can I get
unlimited qoutes in a format compatible with excel?
There's a program called Historical Stock Quotes which can create tab or comma
delimited files that can be read into Excel.
If you want something that updates automatically within Excel, you may have to
buy an add-in. Have you searched the web?
On Sun, 6 Mar 2005 12:18:23 -0800, ZouBCivil
>The Excel Add-in that allows you to retriev...Using a VBscript to copy/delete/move Outlook messages
I need to write a VBscript to:
- open my Outlook (2000 or XP) mailbox
- read the list of the folders in either the Exchange Mailbox and in local
- open each folder and subfolders
- read information about messages (i.e. sender, recipient, creation date,
and so on)
- move, copy or delete messages based on the above information
Can anybody please provide a pointer to a sample I can start from?
...Using XP Briefcase with money file
I put a copy of my money file into the laptop briefcase
and I am able to keep them in sych for a while. For some
reason I get locked out, the computer knows the file has
been updated but it will not let the desk top file update
the laptop file, I get the following message;
"The source file can not be opened"
"Check to see if the other program has the file opened,
and close the file before updating the briefcase."
Other files update just fine. When I get this message, I
can't even drag a new copy of the Money file to my
briefcase, I have to rename the file an...Can you delete and empty an open email
Can you delete and empty an open email? I know I can delete and empty a
closed email by holding down shift and then deleting, but have not been able
to figure out how to delete and empty from an open email.
Is this even possible?
Thanks for your help.
On Wed, 18 May 2005 20:01:03 -1000, Kylie B""
> Hi there
> Can you delete and empty an open email? I know I can delete and empty a
> closed email by holding down shift and then deleting, but have not been
> to figure out how to delet...select database
Prob an easy one but is there a keyboard shortcut to select a whole range of
data (database) in excel. Or select just the filled in data. I know ctrl A
selects all - is there a variation on this?
any help greatly appreciated
You can use Ctrl * to select the current region
Regards Ron de Bruin
"rexmann" <firstname.lastname@example.org> wrote in message news:019FE07A-9C7D-4300-9137-646406AAAA48@microsoft.com...
> Hi all
> Prob an easy one but is there a keyboard shortcut to select a whole range ...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" <email@example.com> 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...Where can I get a template that will calculate profloss after buy.
I need a template that will calculate all the possible variables in a share
trade. The rate on buying, every day entry (7 days),Profit/loss on holding,
prof/loss on sale etc.
...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...Contacts vs Personal Address Book. Can't pull emails into TO fiel
I'm using Outlook 2k3 and having a slight problem. WHen I view my Contact
list in the main view, I have two sets (not sure why but I'll be combining
them). These lists have standard name, email, etc.
Problem is when I go to create a new email message and click the TO: button,
it tries to look for my Personal Address Book which I don't have. How can I
make it not use the PAB and use the Contacts list instead?
OK, I think I just stumbled on the issue. For some reason on my COntacts
Properties, the check box to tell Outlook to use that in the Address Book
...How to remove the /dde from Windows Explorer File Open on Install
I have an MDI app that I would like to open a file on a double click in
Windows Explorer. Unfortunately the Explorer File Type (Tools>Folder
Options... File Types tab) is set so that the command invokes dde. Ie. The
"open" option under the "Advanced" button is C:\Path...\App.exe /dde and the
DDE message is [open("%1")].
This never seems to work as my app never sees the dde message and the
initialization of m_pCmdInfo via:
m_pCmdInfo = (CCommandLineInfo*)(UINT_PTR)m_nCmdShow;
sets the pointer to one and the app fails on exit. This is referred as a
kn...Remove Add-Ins from Tools Menu
I installed an Add-In, used it an then uninstalled it. The Add-In still
shows on the Tools menu. How do you get it off the menu?
I exited and restarted the the program several times and the add-in is
unchecked. Excel 2000, 9.04402 SR-1
Does this add-in have a name?
Some third-party applications are noted for sticking files in XLSTART.
Visio comes to mind.
Gord Dibben Excel MVP
On Mon, 12 Jan 2004 16:31:17 GMT, "Karl Irvin" <firstname.lastname@example.org> wrote:
>I installed an Add-In, used it an then uninstalled it. The Add-In still
>shows on the Tools menu. How ...can't find form
i have a command button on a form [frmMainMenu] that when clicked, closes
that form and opens another [frmFixtureSchedulePrintOptions].
The 2 share the same table as a record source, so i'm doing this to avoid
the code behind [frmMainMenu] reads like this (below), and functions
stDocName = "frmFixtureSchedulePrintOptions"
DoCmd.OpenForm stDocName, acNormal
on the new form [frmFixtureSchedulePrintOptions], there is a command button
to save to close itself, and open the previous from [frmMainMenu], and the
...Using a variable for a chart limit
Since I got instant help on my last query, is there any way to use a cell
reference as an axis minimum or maximum in format axis? It seems impossible,
but there is a lot of experience out there. Thanks in advance.
See Jon's information
Vince F wrote:
> Since I got instant help on my last query, is there any way to use a cell
> reference as an axis minimum or maximum in format axis? It seems impossible,
> but there is a lot of experience out there. Thanks in advance.
Andy Pop...Won't Remember Password #2
My email account calls for the password everytime I use
it. Even when I check the box to remember my password,
it won't retain it.
I run XP. Anyone else having problems with this?
If you are still having problems after applying both the SP 1 & 2 =
patches, then see if this article addresses your problemL
OL2002: The Save Password Setting Is Not Saved When You Connect to a =
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact.
After searching google.groups...