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...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.
...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...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.
...Regular Expression to detect repeating decimal?
Can a regular expression detect a repeating decimal?
For example, given these input numbers, can a regex return these
1.232323 -> returns "23"
1.23456789789789 -> returns "789" (ignores the "23456" before the
1.1371371 -> returns "137" (not 371)
1.13713713 -> returns "137" (not 713)
If a regex can't do all of the work, can it do part of the work,
supplemented by other code?
Greg Lovern wrote on 13 jan 2010 in microsoft.public.scripting.vbscript:
...Excel/Visio Form for entering data
I've seen this done before, just trying to figure out how to accomplish it. I
have an Excel spreadsheet containing a Visio network diagram with text fields
for entering data (IP addresses, etc). I'm trying to recreate this form with
a new diagram. Once I've pasted the Visio diagram into Excel, I'm having
difficulty getting Excel to allow me to specify fields and enter data. There
has to be an easy way to do this. Anyone have a good resource or know how to
...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" <firstname.lastname@example.org> 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...How to create a connection point in Excel
When I group autoshapes the group itself does not have connection points. A
connector connects to one of the grouped shapes instead. So, the connector
beginconnecedshape (or endconnectedshape) property contains the name of the
contained shape and not the name of the group. Is there a way to create
connection points for a group? Alternatively, is it possible to change a
group into a single shape with connection points?
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...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...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 ...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...Windows XP: Open file in read-only: Word, Excel, Visio
I'm often sharing files on a network drive with someone. Often, one
of us knows that we don't need to open a file for modification, and we
only need read-access. Is there a way to open a file in read-only
mode so that when someone does need to open it for modification, the
read-only user is not blocking that?
If there is not a way to do this native to Windows XP, is there a way
to do it from the three applications that we use most, namely Word,
Excel, Visio? All are 2003 versions.
I used to save files like this in "read only recommended" mode.
File|SaveAs|Tools|Ge...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.
...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
...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...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
...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