Trouble with Excel 2000 Help file
Running Excel 2000.
When I click on "See Also" at the top left of my Help screen, I get an
internet explorer error message:
"An error has occurred in the script on this page" Line1, Character 1. It
goes on with some other stuff.
Also, at the top of the page, I don't see hyperlinks anything else, but I
see two little blue squares with a dot in the middle of each, which I
usually associate with images that don't download.
I seem to have my help files confused. I've tried reinstalling Office, but
that doesn't help.
I've gone to the microsoft support w...Drop-down list #5
I created a drop-down list in a separate sheet in my workbook. I named it
Vehicles. Now I want to add to the list, but I can't figure out how to do it.
I know ig must be so easy, but I'm stumped. Please help.
If it's a one-time occurrence, you can press Ctrl+F3,
click on the name, and extend the formula. Otherwise, I
would make the range dynamic. You can learn how to do
>I created a drop-down list in a separate sheet in my
workbook. I named it
>Vehicles...exporting outlook 2000 pst files to a database
I need to export outlook 2000 to a database- attachments
and all. Is there a simple way to do this so you can search
and retreive messages and attachments in a database form?
You can export individual folders to access or excel to have them available
for searching. I have never tried to export my entire .pst file to access
or excel however.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact.
After searching google.groups.com and finding no answer
Jeff <firstname.lastname@example.org> asked:
| I need to export outlook 2000 to a database- ...help #4
I have two work sheets that have some releases on one sheet in
column (F) that mark Total Available.
The other work sheet that mark Commitments have a validation list that
mark Head / Sub - Head Item / Sub - Item in column (F)
The validation listings are difference listing under.
In the Commitment work sheet when I put in the amount under Value of
and click a listing in the validation list it must reduce the amount
under the difference releases.
(E.g let say that I had $50,109.62 dollar balance under upkeep in the
releases column and I buy some cups that cost $...lil help with "or" formula
I am trying to return a "false" value if there is text in cells E2:I2.. the
only formula i have come up with so far is
but this returns the opposite value of what I want, it tells me "true" if
there is text...
"Murph" <Murph@discussions.microsoft.com> schrieb im Newsbeitrag
> I am trying to return a "false" value i...office 2000 [excel] cannot open previously OK file. Help
When trying to open a Microsoft Excel Work Sheet that I had accessed modified
and saved to only yesterday [Office 2000] a window pops up with:
"name.xls cannot be accessed. The file may be resd-only, or you may be
trying toaccess a read only location. Or, the server the document is stored
on may not be responding."
Older files stored on the same mediums ;HD, Flash memory or 3.5in. diskette
are accessed with no problem.
This is on a network drive?
...Excel and some disappeared sheets
Anybody has the same or similar experiences :
- I worked with excel file / closed as usually
- new day opened and unfortunatelly some very important sheets
disappeared / why ? Don=B4t know
- I had about 7-9 sheets just now only 3 ones are there but not so
important as another ones
- the file has original size / I quickly looked into file by normal
text editor only for reading
and all relevant data are there, however if I open file by Excel, NO
original sheets or data
- this file is VERY IMPORTANT for me
- why happened ? Don=B4t know since I ask anybody for help
Thanks in advan...Lookup
i have 3 fields called Site(lookup), Board(lookup) and Location(text).
there is a field name which i want to populate automatically with on change
event = site + location + board
below is the code i have
var lookupItem = new Array;
lookupItem = crmForm.all.parentcustomerid.DataValue;
var l = crmForm.all.new_location.DataValue;
var boardlookup = new Array;
boardlookup = crmForm.all.new_boardid.DataValue
if (lookupItem != null)
n = (lookupItem.name)+" "+ l +" "+(boardlookup.name) ;
crmForm.all.new_name.DataValue = n;
n = ( l +" &qu...Outlook 2000 not opening.
I am having a major problem with outlook. Can anyone tell
why Outlook will not open when selecting it. When I check
in the processes there is an instance of Outlook.exe there
but it is not doing anything. When a different user logs
onto the machine Outlook will open fine with no problems.
I have deleted the users profile and recreated it but to
no use. I have tried comparing the local registry keys of
the two users and they seem to be the same.
Can anyone please help me as I have ran out of things to
Thanks in advance.
Does Outlook start in /safe mode? (I'm assumi...Offline Folders #5
I am trying to get an outlook client setup so that it
automatically opens offline without prompting the user.
Does anyone know if this is possible, if so how to do it.
In the properties of the e-mail account (Tools, Options,
Mail Setup, E-mail Accounts, View or Change existing e-
mail accounts) if this is an Exchange e-mail account,
highlight it and hit Change, then More Settings. Select
Manually Control Connection State, then select Work
Offline and Use Dialup Networking. This should give you
the desired effect.
>I am trying ...OWA. CA's. and Exchange 2007
The other day, I had to renew the Certificate on my Exchange 2007
server. Everything seemed to go alright, but eventually I received
complaints that outbound email wasn't being sent. Looking at EMC
showed all of the email queued up and waiting for something. After I
relaxed the settings on my router (Allowed all outbound SMTP instead
of restricting it to the Exchange server sending to MxLogic) all of
the outbound email went though.
I also was receiving reports of Webmail being broken (which was
halfway fixed with the help of
http://www.microsoft.com/technet/support/ee/transform.aspx?Pr...Access 97/2000/2003 comparisons
I have a rather large application that uses an access 97 database (DAO). We
also have a version that works with access 2000, Oracle, msde, and SQLServer
(ADO). We would like to retire the DAO version of the product, but there are
places where the ADO version is much slower compared to where we run DAO
seeks (very noticeable when looping). So, I have a few questions.
1. Are there any tips/tricks to speed up ADO queries to compare with DAO
2. Would there be any benifit in using access 2003 over previous versions of
the software besides the added features (xml support, etc).
3...Multiple domains on one Exchange server / All but one domain shows up as spam #2
I am sorry if this is on the board somewhere but I have been searching
forever and havn't found a hint yet.
I have multiple domains setup on my exchange server. Lets say abc.com,
def.com, and hij.com. We only send email with @abc.com but can receive
from any domain name. Recently we merged with another company and we
brought back their email to our server, lets say xyz.com. Now I
configured a new recipient on Exchange 2003, so I now have two
policies. The first policy has the three original domains in it with
@abc.com as the primary domain. In the second policy I have configured
xyz.com t...Can't create Organizational Forms Library in Exchange 2003 with SP
I cannot create an Organizational Form in EFORMS REGISTRY folder (from First
Administrative Group->Folders->Public Folders->EFORMS REGISTRY in ESM). When
I right-click the EFORMS REGISTRY folder and select New, there is no
Organization Form. Instead, I only see Public Folder in the popup menu. Do
you have any idea why Organizational Form menu does not show?
My Exchange Server is Exchange 2003 with SP2. The login user is Administrator.
Could you please help me? Thank you very much.
Is that account member of "Enterprise Admins" group?
Yang Zhang wrote:
&...Event ID: 8270 ,LDAP Error--Need help to fix it..
Event Type: Error (win2000 Srv+exchange2000)
Event Source: MSExchangeAL
Event Category: LDAP Operations
Event ID: 8270
LDAP returned the error [b] Administration Limit Exceeded.
: CCMAIL:User1, PO at NET
: smtp:USER1@MAILLIST.Domain_Name.Domain_...OL2002 Problem : HELP, SOS, MAYDAY
I have an IMAP account and OL2002 as client.
I have checked for my account ( tools, send/receive
settings, define send/receive groups, <my_account>,
edit) download item description only.
It works only the first time I start OL2002, but it does
not work anymore for subsequent automatic/manual
Please could someone really help me ?
Thank you in advance,
...Moving Exchange #5
I am needing to move my Exchange server off of the SBS box that it is
currently on and move it to another, new server. I cannot keep the servers
the same name as I need the old server to continue to run SQL. Are there
white papers on how to do this?
On Fri, 18 Aug 2006 08:43:40 -0700, scottdog129
>I am needing to move my Exchange server off of the SBS box that it is
>currently on and move it to another, new server. I cannot keep the servers
>the same name as I need the old server to continue to run SQL. Are...request to solve my problem #5
hello friends this is vijay,i got a problem while doing my project
based on vc++ (i.e)"How to implement Fit Window feature in VC++6.0 in
an MDI Application" if any of you got any idea about that please do
reply me with the proceedure.i will be waiting for your reply
...140 MB file went to 5.08 MB after editting 1 table
Hello All -
I need some ACCESS insight...please...
Several years ago, I built an access db to track my business
scheduling and accounts payable/receivable.
So this database is EXTREMELY IMPORTANT TO ME.
The file has grown to 140 MB.
Today I made a copy of the file and then edited my calendar table.
I removed all columns which had 2006 data (72 totals columns) - the
table had about 144 columns originally.
I then added 72 columns with 2008 headers. These columns are now
blank since I have not added any 2008 data yet. Afterwards, I looked
around and everything looks good - my 2007 data is the...Backing Up Exchange Database
I am running Exchange 2003 on a Windows 2000 server. Veritas Backup 10, is
installed on the server. The Exchange Agent is also installed on this
server. A full backup with the option to clear committed logs is used to
perform the daily exchange backups.
I noticed that in the MDBDATA folder the logs are continuously being added
approximately 5MB in size. Is there a way to have these logs removed
automatically as I thought that the backup would perform that function.
On Thu, 5 Jan 2006 17:18:02 -0800, microsoft
>...Exchange 2003 IMAP and Postini
Hello all --
I have a problem and I was wondering if the smart ppl out there could come
up with a solution.
I've enabled Secure IMAP for our users with cell phones with pocket PC
installed on them... Basically, we are using Postini, and they want you to
ONLY accept connections from their servers, so as to not allow SPAMers to
directly connect to the exchange server and directory harvest attack.
However, when Idid that, my IMAP ppl can't SEND email anymore because they
aren't coming from the trusted IP range. Is there anyway around this?
Probably not, but I thought I'...Help With Margin Formula
I need help with a margin forumla (calculated from retail). Say I have a
cost of $10.00, and I need the formula to calculate a 40% margin from
retail. So the retail should end up at $16.67. Not sure how to get from
$10.00 to $16.66, I just know the cost and the margin I need to make.
"JR" <email@example.com> wrote in message
> I need help with a margin forumla (calculated from retail). Say I have a
> cost of $10.00, and I need the formul...Limit on Exchange 2003 version included with SBS 2003
Can anyone tell me if the version of Exchange 2003
included with Small Business Server 2003 has the 16GB
limit that exists in the Exchange 2003 standard edition?
>Can anyone tell me if the version of Exchange 2003
>included with Small Business Server 2003 has the 16GB
>limit that exists in the Exchange 2003 standard edition?
...GETPIVOTDATA data_field help
When I enter a reference to a cell, eg A2, as the value for the data_field item in the GETPIVOTDATA I get a #REF error. However, when I instead type the value of A2, eg 2003, manually into the GETPIVOTDATA formula, it works. Can anyone please help--I want this formula to vary based on what is in A2.
This function is so variable in action, and difficult to handle, that
have given it up in favour of VLOOKUP. In fact, having no problem i
use with pivot tables
Message posted from http://www.ExcelForum.com
Try copying the headings from the pivot table, and pasting them into the
I'm just wanting to write some 'proof of concept' scripts relating to
Exchange that would help in troubleshooting any issues. Like the Exchange
Are there any other qualitative data that can be used in general