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...PNG files not displayed
I have a problem where PNG files I insert into Publisher aren't correctly
displayed. The image place-holder is visible, but no image. Other graphics
file-types are fine, but not PNG's. Another user with identical hardware and
software can view the same PNG's without problems. I've tried resintalling
Office and service packs with no success. However, when printing the
publication, the PNG graphics are produced with no problems.
I'm running Office 2003 sp 1.
Thanks in advance!
Casey <Casey@discussions.microsoft.com> was very recently heard to
utte...Problem to open excel file
Hi to all,
I have a problem with all excel file. The user can't
open all excel file when she did a double click on it.
She has this error message :
"cannot find the file 'c:\documents and
settings\desktop\......test.xls' (or one of its
components). Make sure the path and filename are correct.
And that all required libraries are available"
Do you know what can I do to solve the issue??
Your Excel file association may be lost.
Start>Run "excel.exe /regserver"(no quotes and note the space before the /
You may have to en...Importing a Lotus file with a *.123 extension
My company uses Excel 97 and 2000 and we've received a
Lotus file with a *.123 extension. Excel will not allow me
to open it as it does not have the *.wk? format. I
searched the web and while I found numerous people with
the same problem I found no one who had the conversion
answer. Any help would be greatly appreciated. Thanks
Find someone with Lotus ver 9 or higher. Have them open the file, and save it
If you dont have Lotus available and want you can send it to me and I will do it
"jim" <email@example.com> wrote in message
news:088d01c35...Excel is creating temp files Help!!!
Hi i have to files in excel, i cant figure it out, whenever i open th
files, they create temp files into the same location, when i shut dow
the program the temp files are left there.
Is their a way to make it so temp files are not saved.
Or is their a way to make it so that the creation of temp files i
greenfalcon's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1362
View this thread: http://www.excelforum.com/showthread.php?threadid=26182
What do th...Navigation Bars
I put Navigation bars on my publisher website document. When I try to publish
to a file or to the web, the Navigation Bars do not appear on the page(s).
How do I resolve this??
Answer found in the web group.
"Tom Snyder" <Tom Snyder@discussions.microsoft.com> wrote in message
>I put Navigation bars on my publisher website document. When I try to
> to a file or to the web, the Navigation Bars do not appear on the page(s).
> How do I resolve this??
Tony, did you get an answer to this...How do I Restore old save dbx files back into OE store folder
I have some old dbx files that I saved into a folder in 'My documents' some
time ago during earlier OE back ups. I now wish to re-import some of these
saved dbx folders back into OE in order to assess some of these emails
again. I've been looking at the wed sites 'Inside OE' and 'OE help'. But
can't seem find or see the part that will give me directions on how to do
Some of these saved dbx folders have the same names of existing folders that
I'm currently using in OE. So presumably, I'm going to have to do some
folder renaming or s...ANN: xsdbXML release with C#/.NET port
ANN: xsdbXML release with C#/.NET port
Part I: Announcement
There is a new release of xsdbXML which provides
bugfixes to the Python implementation and also
provides a completely separate implementation in C#/.NET.
The xsdb framework provides a flexible and well defined
infrastructure to allow tabular data to be published,
retrieved, and combined over the Internet.
Read more and download at
Part II: Discussion
The C# implementation is primarily a transliteration
of the Python implementation. I hope to also do a java
tr...How Do I Copy My Outlook Files To My New Computer?
I exported my Outlook files from my old computer and burned them to a
CD. During the export process, it asked me three times for a password.
When I tried to import these files to my new computer I got "File
access is denied. You do not have the permission required to access
the file." Can anyone help?
Apart from the fact that Import/Export options often lead to corruption -
you should use a simple pst copy -
The pst needs to be on the hd and the read only flag off, before In OL
attempting to open it. NB not import
<firstname.lastname@example.org> wrote in message
news:1145746658.84...OMA vs Blackberry
I have a mid-sized Enterprise with about 500 users on two exchange
servers. We have a new CEO who wants a Blackberry. This has become
something of a priority. While I have the approval to pay the $10k or
so it will take to get a server, the BES software and assorted other
expenses it will take to get his going, I have now heard about Outlook
Mobile Access (OMA) being available directly through Exchange with SP2.
Does anyone know if OMA is really a competitor with Blackberry? Does
it offer more or less? Any key differences? Is this real? Can I use
Blackberry devices with this? (I reall...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...viewing LN emails (.nsf files) saved to CD in outlook?
I have lotus notes messages saved on CD, these are saved
as .nsf files. Is there any way I can view these in
have tried various LN websites - to no avail.
...Multi-language MFC app: how to?
I'm looking for a good way to 'translate' my MFC app to multiple language.
I'd like to use a single binary and if possible allow switching
languages and maybe even changing strings while the app is running.
Are there any how-tos for this?
Olaf van der Spek wrote:
> I'm looking for a good way to 'translate' my MFC app to multiple language.
> I'd like to use a single binary and if possible allow switching
> languages and maybe even changing strings while the app is running.
> Are there any how-tos for this?
I am also star...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 ...Help with automating file name
I have the following code that exports the below query to excell. I would
like the files name to include the month and date. How would I format this?
DoCmd.OutputTo acOutputQuery, "qryShopOrderSqFtShippedSummaryExport",_
mattc (at) saunatec [dot] com
Message posted via AccessMonster.com
> I would
> like the files name to include the month and date.
Uh, . . . the date _always_ includes the month, unless you're r...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...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...outlook adreddbook file
I want to export the addressbook flie into database to be
uses in a quiry. is it possible and how do i do it?
Outlook has no separate "address book file."
Contact data is stored in your Contacts Folder Use the Export Wizard to
export it to the format that best suits your needs.
"Helpneeded" <email@example.com> wrote in message
> I want to export the addressbook flie into database to be
> uses in a quiry. is it possible and how do i do it?
...Contact file not visible when importing or exporting contacts
I'm tidying up all my contacts files for email and also for my mobile ph
using outlook. Have done this many times without any problems and am familiar
with import export process.
I exported all the contacts to an excel file to work on as it's much easier
than through outlook. Had a hiccup at first as when I got to the select a
contact file to export there was just a blank space. I exited outlook and
went back in and it was all OK.
Now I've finished the excel spreadhsheet and want to reimport it but it's
the same problem in reverse. I can't "see" a co...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...Force command to run for each computer in txt file list of compute
I have a few hundred computers that haven't been defragged in years. I was
wondering if rather than doing it manually, if someone had a script where if
i just put all the computer names in a txt file, it would iterate through the
list and perform a "defrag c: -f" on them all from my workstation. The
workstations all have the same local administrator password, so the process
would be the same for each. I just dont know how to write scripts.
I know if i were going to do this manually from my computer I would run the
command below for each ComputerName
psexec ...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...