Excel 2002 calcs slower than Excel 97
I just upgraded from Excel 97 on NT (2.8Ghz w/1GB Ram) to Excel 2002 on XP
(3.0Ghz w/1GB Ram).
Excel 2002 now seems to calculate a LOT slower. It seems to happen more
when I've imported data from an Access query. But even after I've broken all
of the links to the access query the calculation now takes on average 10-14
minutes!!! This used to take less than 1 minute.
I'm open to any ideas... lets hear your suggestions & questions!!!
...Numbers starting in 0
I have a csv file that has PO numbers in it. Some of the PO numbers start
with zero, which is required. When I open the file in Excel 2002, Excel
drops the zero off thinking it is a number not text. How can I keep Excel
from dropping the 0 off?
Try changing the file extenstion to .txt When you import
the file, set the column with the PO numbers to text
>I have a csv file that has PO numbers in it. Some of the
PO numbers start
>with zero, which is required. When I open the file in
Excel 2002, Excel
>drops the zero off thinking it is a n...Is it possible
I would like to know is it possible to make million dollar in the internet, if you have any suggestions, write on my forumhttp://isitpossible.truemillion.comMark...How do insert page numbers in excel
how do i insert page numbers in excel as it appears in word?
You create a footer. Use File>Page Setup>Header/Footer>Footer>Page 1
Please reply to newsgroup, not e-mail
"Timothy" <Timothy@discussions.microsoft.com> wrote in message
> how do i insert page numbers in excel as it appears in word?
...How do I create a dual axes column chart in Excel
Hi...I am trying to create a dual axes column chart in MS Excel 2003. But the
moment I add the secondary axis the bars are getting overlapped.
This example should help:
> Hi...I am trying to create a dual axes column chart in MS Excel 2003. But the
> moment I add the secondary axis the bars are getting overlapped.
...Personal Folders in OWA
I have just enabled OWA on our Exchange 2003 SP2
through ISA Server 2004. Is there any way to
access personal folders in OWA?
Thanks in advance.
If by personal folders you mean .pst files, the answer is NO! Sorry.
C C wrote:
> I have just enabled OWA on our Exchange 2003 SP2
> through ISA Server 2004. Is there any way to
> access personal folders in OWA?
> Thanks in advance.
"C C" <firstname.lastname@example.org> wrote:
>I have just enabled OWA on our Exchange 2003 SP2
>through ISA Server 2004. Is there any way...Excel asking for save with no changes #5
Dave Peterson Wrote:
> And xl2002 added an option that allows you to have more control:
> Edit|links|startup prompt button.
> check the "don't display the alert and update links"
This sounds like exactly what I'm looking for! Unfortunately, I'
running an older version of Excel. I'll have to hit up my IT perso
for an update. Thanks!
tommy20's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=281
View this thread: http://www.excelforum.com/sh...Record Locking Multiuser
I have created a multiuser database. In order to prevent more than one user
editing the same record I have set the record locks to "edited record"
This seems to create a lot of unwanted record locking issues for the users:
Some records get locked and the only way to unlock them seems to be closing
and reopening the database.
I have thought about putting some unlock buttons on the forms but it would
not work because I have another automated way to lock the records: when the
record is complete a supervisor enters his/her name on the form and this
action locks the record to all ...excel in browser
hi out there
Could you tell me if there is any chance to use cmd button
to print preview (i.e charts, sheets, ranges,.) when excel
file is open with internet explorer.
I've created excel application myself and just recently
found out that my file is to be hosted externaly on one of
virtual learning environments (VLE) sites.
When I uploaded my file onto (VLE) and then open with
browser cmd buttons with printpriview methods caused error
message "Print preview method of chart,range,.. class
failed". Also I used to read from text files to obtain
some information and display ...Downloading Statements Directly Not Possible
I have Money 2002 installed on an Win XP Pro SP1 machine. Something
happened and I probably did it, that causes the statement downloads not to
go directly to the account. Rather they want to be saved in a file and then
opened into Money. I then have to delete the download.
I have tried several things in order to fix this:
1. I verified the file associations of OFC, OFX were correct. They were.
2. Lowered all my security settings in IE. Even put banks into Trusted site
zone. No go.
3. Made new accounts. Didn't help.
4. My IE cache is large (500MB) and regularly cleaned out.
5. I made s...How do I copy a Word File to an email that has numbered lists in
When I send an email and copy a Word Document that has a numbered list in the
body such as 1. 2. 3. etc. the numbers for each line disappear in the
email message. How can I prevent this?
Email messages generally don't preserve formatting. Send the Word doc
as an attachment, or (probably better) convert it to pdf and send
On Feb 23, 4:05=A0pm, Edward P <Edward P...@discussions.microsoft.com>
> When I send an email and copy a Word Document that has a numbered list in=
> body such as 1. =A0 2. =A0 3. =A0etc. the numbers for each line disappea...is this possible? reload a form that is based on a query with new query that is defined in the form.
I have a basic form.
The form is based on a query, so when I open the form, a pop comes up
where I enter in what I want to query.
So instead of 30,0000 records, I get 1-10 records.
on the form, I have a text box. I want to be able to enter in what I
want to query next and afterupdate have the recordset/form reload with
that query instead of my original qeury.
I figure this has to be done with VB. I am just starting to learn some
VB but I am lost.
Any info would be great, thank you.
You need to apply the new query or table name, or the sql string to
the forms recordsource, then...converting numbers into words
Does anyone have a script to convert numbers into words (e.g. in the way you
would print on a check)?
Have a look at the KB article here to build your own Function
OR Download MOREFUNC.XLL from Laurent Longre's site. Does this(NumText) and
Gord Dibben Excel MVP
On Sat, 2 Oct 2004 15:40:52 -0400, "Joerg Reutershan"
>Does anyone have a script to convert numbers into words (e.g. in the way y...Saving Record using Access FE to SQL BE
I'm using Access 2003 on the front end and SQL 2000 on the backend. When I
click on a button on the front end form to save a newly created record,
what's the coding to save that record to the SQL server table? The form
source is linked to the sql table.
Thanks for your help,
Message posted via http://www.accessmonster.com
If you've created linked tables to SQL Server and are binding the linked
tables to your forms, you don't need to do anything to save the data: it'll
automatically be saved when you move to another record, just as it does when
you're ...hosted email PTR records
We hosted several clients emails. (such as client.com; client1.com..)
Their MX records point to our Exchange servers (A record). what about the
PTR records for mail.client.com; mail.client1.com...? Should I ask our IP
provider to create PTR records for mail.client.com; mail.client.com as they
have PTR record for mycompany.com already? Can one PTR (ip address) point to
different host names such as mail.mycompany.com,mail.client.com;
mail.client1.com...? Will it affect mail delivery?
The reason you have PTR records for your domain and mail server is beca...I need an excel plug in to save workbooks in adobe acrobat format
I used to have this feature on the toolbar, but following a severe recent
excel and outlook crash, it got wiped off !!
There seems to be no way to restore this essential facility, of choosing to
save excel workbooks in a pdf format instead of xls.
DOes anyone know how to restore it?
Hi Chris, Try-File, Print, then select Acrobat Distiller. It will then ask
you where you want the .pdf file to be saved. Thats how it works on mine.
Hope that helps
"chris brown" wrote:
> I used to have this feature on the toolbar, but following a severe recent
> excel and outlook crash,...Possible to detect changes to an XmlDocument object?
If I instantiate an XmlDocument object, the load a file through the Load
method, is there a way, later on in execution, to easily determine if the
XmlDocument object has changed from the original version loaded?
I'd like to be able to check a condition to see if the document in memory
has been editted (i.e., nodes added, attributes changed, etc.) so that my
user can decide whether or not to commit changes to the disk file before
moving to another file.
Will I have to resort to re-loading the file, and comparing OuterXml
Gabe Covert wrote:
> I'd like t...Trying to add or save a record.
I tried this awhile back and gave up. Trying again.
I made a form with two tables, customers & calls.
When I enter the phone number from the customers table that exists it
populates the form the way I want it and I can save the form or add a new
record and I think it is saving it in the calls table.
If I enter a phone that doesn't exist and try to exit or enter a new record,
I get the following.
The microsoft jet database engine cannot find a record in the table
'customer' with key matching field(s) 'Phone#'.
What I am trying to do is save the form even though ...Is it possible to compare a string and a field name
I have the following tables: Membership, Subscriptions, OfficeUseOnly. The
Office Table contains a Year, Year To and From [financial year] and the other
fields are the 5 membership types (regular, student etc) and these 5 fields
contain the different amount each type of member has to pay.
I want to create a form whereby on entering the financial year and the
membership type the correct amount is automatically inserted into the
FinancialYear - in current form = OfficeUseOnly SubsFinYear
and then if MemberType = 'Student' find Student field ...pictures in various shapes
Is it possible to insert a picture and make it into a circle or an oval or
various other shapes than just squares and rectangles? Thank you ahead of
with a graphics editor
Microsoft MVP - FrontPage
"Stephanie" <Stephanie@discussions.microsoft.com> wrote in message
| Is it possible to insert a picture and make it into a circle or an oval or
| various other shapes than just squares and rectangles? Thank you ahead of
> Is it possible to insert a pict...Excel 2002 SP3 CSV Format Cell 'Special' Leading Zero
Excel 2002 SP3, CSV File, Format Cell 'Special' for Zip
Code Leading Zero does not work.
Is there any way to maintain the Zip Code Leading Zero
(New England States) in a CSV File? I have tried
Format 'Special' and 'Text' and have found the only
solution to be to place a leading ' with each zip code.
This is not a very practical solution.
Is this a configuration problem, a bug, or a limitation of
the CSV file?
you may use an adjacent cell with a formula for this. e.g. enter in B1
or something similar according...Create sequence number for table
I have a table with a Title field, comment field and a Sequence field. I
would like code to sort the table by Title and then fill in the Sequence
field based on the order of the records. The first record would have a
sequence number of 1, the second record a 2, etc.
Can someone help me with code to do this?
Thanks in advance.
"Phillip" <Phillip@discussions.microsoft.com> wrote in message
> I have a table with a Title field, comment field and a Sequence field. I
> would like ...Randomly select a record in a table
How would I randomly select a record from a table that has some 2500 records?
Any help is greatly assisted!!
many thanks in adavnce!!
On Sun, 18 Apr 2010 16:17:01 -0700, DontKnow
>How would I randomly select a record from a table that has some 2500 records?
>Any help is greatly assisted!!
>many thanks in adavnce!!
SELECT TOP 1 *
ORDER BY Rnd([fieldname])
where [fieldname] is some Number or Autonumber field which can be counted...Store sizes and number of mailboxes.
with Exch2003 SP2 what is the fastest way to find the information in the
subject? Does MOM tellyou the store size and number of mailboxes?
On Feb 9, 1:16 pm, Tyson <T...@discussions.microsoft.com> wrote:
> with Exch2003 SP2 what is the fastest way to find the information in the
> subject? Does MOM tellyou the store size and number of mailboxes?
My firm uses a Quest Product called MessageStats. There are tons of
reports you can run such as mailbox sizes, number of mailboxes,
activity information per mailbox, server activity, etc... Its a nice
tool, I use it every day.
On ...Is this possible
I want to make a list of the files in several different
folders. Is it possible to somehow "Copy and paste" just
the filenames into a list, in either Word or Excel or
Wordperfect. I am just trying to sort the files in
several different folders to weed out duplicates. There
has got to be an easier way then typing them all or screen
printing the lists and manually weeding them out. Any
Here is some code that will start in a directory and list all files in that
and any sub directories. It uses recursion to go through all the subs.