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...Security Descriptors not updating
Anyone else having, or have had this problem when updating a custom role?
...Updating a table from Form Entry
I have a form that pops up when a user clicks a button to Print said form.
The form is for the user to enter the name of the table and any footnotes for
that particular form, this form is connected to a table that stores this
information for everytime the report is printed. THe problem I having is that
when the user enters the information and clicks [PRINT] the report is blank,
when I open the table the info the user has entered has not updated onto the
table yet. Is there a way so that when the user clicks [PRINT] the footnote
table will update BEFORE the report prints?
Neve...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.
...Money 2005 Trial Download Gone! Stuck...
I bought the download edition of money 2005, re-installed my system,
but don't have the "Trial" version of Money 2005 to install/upgrade to
the full paid for version (download). Now that 2006 is out that's all i
can find... Am I forced to upgrade? Or is there a place I can still
In microsoft.public.money, Hrrglburf wrote:
>I bought the download edition of money 2005, re-installed my system,
>but don't have the "Trial" version of Money 2005 to install/upgrade to
>the full paid for version (download). Now that 2006 is out that's all i
&...Update textbox on form
The following are events on two combo boxes on a subform "NewJobsSubform",
the first sets the rowsource of the second and also sets a default value in
the second. The second event sets the value in the text box "Sell" to the
price associated with the RepProduct in cboRepProduct - collected from the
"Private Sub cboCatName_AfterUpdate()
On Error Resume Next
Me.cboRepProduct.RowSource = "SELECT RepairProduct.RepProduct FROM" & _
" RepairProduct WHERE CatName = '" & Me.cboCatName.Value..."All users" "Programs" create/modify shortcut from app...
I've created two shortcuts into "Programs" folder for "All Users"
It lets me to get them available for all user.
Application running in "User" context needs to delete and re-create such
links but it fails due to an "access denied" ...
Settings correct permission to such links it starts working as well
I've created links using the IShellLink/IPersistFile sehll interfaces.
So, I actually need to have link under "programs" for "All Users" which
might be modified by application running in "Users"...Microsoft Money Deluxe 2004 #2
How do I install on a drive other than C? I am running Windows XP Home
In microsoft.public.money, Don wrote:
>How do I install on a drive other than C? I am running Windows XP Home
Early in the install process, Money has a place to click to change
where the installation is to take place.
If you install in a drive other than the system drive, there could
be an issue. I was thinking there might be, but I don't find a
reference. http://support.microsoft.com/kb/79917/en-us implies that
There is no problem. I have always installed Money (from M...think cell program
is anyone familiar with a program called think cell? Any thoughts?
(powerpoint v 2003). Is this an add-in?
It's very good. You can "try for free" from their website:
Recent interview with one of the founders on Indezine:
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2010? http://www.echosvoice.com/2010.htm
Fixing PowerPoint Annoyances http://tinyurl.com/36grcd
PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/3...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...Money 2005 Closes Abruptly
I am using Money 2005 Premium and all of a sudden everytime I perform an
update now, the program closes immediately for no known reason. Any changes
I made are still there when I open the program again, but I cannot execute an
update now on various accounts.
Any ideas or help?
I figured a work around. Selecting one or two updates at a time works, but
doing all accounts and investment stuff at the same time causes the program
to immediately shut down.
> I am using Money 2005 Premium and all of a sudden everytime I perform an
> update now, the pro...Shortcut dircetly to contact info from other programs?
What is the format for directly accessing Outlook contact
folders from another program such as Excel or Word. I
have done this and since forgotten the format.
jeff <email@example.com> wrote:
> What is the format for directly accessing Outlook contact
> folders from another program such as Excel or Word. I
> have done this and since forgotten the format.
Outlook is the only application that will open Outlook folders. If you wish
to mail something from inside Excel or Word, the "E-mail" button seems to be
what you want.
...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 ...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...Money plus Deluxe Where do I find Balance sheet and Profit and Los
I have Money Plus Deluxe ver 7.0120.1415 My new accountant asked me to print
out the balance sheet (aka Assets, Liabilities, and Equity) and the Income
statement (Profit and Loss) reports? Where do I find them? Does Money Plus
Deluxe have them?
In microsoft.public.money, bigwahoo wrote:
>I have Money Plus Deluxe ver 7.0120.1415 My new accountant asked me to print
>out the balance sheet (aka Assets, Liabilities, and Equity) and the Income
>statement (Profit and Loss) reports? Where do I find them? Does Money Plus
>Deluxe have them?
Go to the Reports list, and look around. T...Setting default program for viewing pictures
How do I set the default program for viewing picture
attachments? I use Outlook Express 6 and when I click to
open an attached picture it opens to JASC Paint Shop Pro
8 but no picture appears. In the past Explorer opened up
my pictures. Can any one give me the steps to change the
default from paint Shop to Explorer??
Change the program that starts when you open a file
starts+when+you+open+a+file&Scop...Is your microsoft office outlook download update looping?
In article <3F7B4D82-187F-4022-BF52-C085A98CF410@microsoft.com>,
If you're talking about the outlook (hotmail) connector - yep - that's
what it does for several of us it seems.
Use this link:
Or if you cannot unwrap, get the link is connected to from this page:
Yes, I am experiencing same thing.
"...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?
...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...Money 2006 Standard Settings/Preferences
Could anyone tell me where the setting is in Microsoft Money 2006 Standard
is to stop it from putting the banks downloaded names in the list of payees?
When entering a transaction in the "Pay To" list that drops down, it seems
to be showing every downloaded entry name from the bank when I thought that
I have my preferences set to use the user names for transactions. This is
very annoying as every time lately that I have been downloading transactions
and making new entries into the ledger it seems that the payee list gets
longer and longer!
This is what I am u...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...Send button not showing after updating to SP3
I have updated the office 2002's .msi file with SP3 for
network distribution. After redeploying the updated file
I few users do not have a send button when the try to
send a message. I have tried to delete their accounts and
set them up form scratch with no luck. My only work
around was to install office from CD. I need to resolve
this problem. The installation from the network is a