Help with a formula please.
In column "A" I have about 400 file names with each path, for example:
Each file contains a value named "ATT" and another named "XBB". I need to
get these values in adjoining columns. I've tried every variation of the
following I can think of without success:
None have worked. I'm sure I have done this before but can't remember and
can't find any of my old files with an example.
More like: A1&"!ATT"
"jim...Excel Progrom Error
Happy new year to all.
I often receive the folowing error message in a box titled "Program
EXCEL.exe has generated errors and will be closed by Windows. You will
need to restart the program.
An error log is being created.
The only option is OK which closes Excel. I do not know where the
error log is created.
I am using Office 2000 Service Pack 3 with Windows 2000 Professsional
Service Pack 4.
Can anybody throw some light on this error.
Thanks in anticipation.
What are you doing at the time (i.e. is it consistent)?
----------------...Sharebuilder account import error
Invalid .qif header error when trying to import .qif file from sharebuilder
Anyone know of a fix or experienced this problem??
I typed a long mail to sharebuilder regarding this issue...still waiting
fora reply. Hopefully they will be able to help. Microsoft flat out told me
it wasn't their issue and to contact my broker! No help AT ALL.
...DPM2010 RC Errors on secondary server.
We have recently upraded our 2007 SP1 Primary DPM server to 2010 RC and it is
I've set up a brand new, fresh Windows 2008 R2 Server for the secondary
server, and have told it to protect one of the protection groups on the
Everything works for a little while, but every half hour or so, the DPM
service crashes and says:
"Connection to the DPM service has been lost.
Review the application event log for information about a possible service
Then asks to restart the administrator console. This kills the ...Help with Formula Please
I have the following formula in cell c1 in a spreadsheet:
200 over - 195
200 over + 205
200 under FALSE 205
200 under + 195
What I've done above is test the formula for all four possible
outcomes. As you can see the third outcome in the table (the fourth
argument in the formula) is false, but I want it to read "-".
I have changed the formula around every way I can thi...ERROR
I am using a spreadsheet in Excel 2002 on Windows XP, for some reason the
account numbers (which someone input, along with addresses) have a little
green mark in the corner of the cell. I thought it was to show that there is
a comment, but it is not. When you click on the cell, a little warning sign
shows, saying ERROR - number in this cell formatted as text or preceded by an
apostrophe. When I click on the arrow by the warning sign, it says
Number stored as text
Convert to number
Edit in formula bar
Error checking options
Show formula in audinting toolbar
Now I looked a...error, chkdsk
Questio, when I try to open excel or winmx, an error pops
up saying chkdsk, so i ran a chkdsk and it doesnt do
anything. The error also says corrupted file. In excel I
have some important work that I need to open, and it only
opens in Turkish, if I change it to English, its a bunch
of boxes and letters, its not my work I need. How do I
change it back.
What excel version are you using? Try to find somebody with 2003
to see if they can open the file. Otherwise you would look for
some commercial software that might be of help
I have problems on one client that they don't recieve all emails from people
sending to them. I guess something is wrong in the configuration. When I do a
nslookup -type=mx domain.com I just get unautharized answer. Also the ttl
time is just 1800 when I do a dns report. Do the guys that handle the dns
The people that doesn't get their mail throw get the 4.4.7 error in return.
Ed Crowley MVP
"There are seldom good technological solutions to behavioral problems."
I am receiving the following error messages, please assist
Could result be sent to email@example.com
Your server has unexpectedly terminated the connection. Possible causes for
this include server problems, network problems, or a long period of
inactivity. Subject 'brocolli & mushroom stir fry noodle', Account:
'pop.gmail.com', Server: 'smtp.gmail.com', Protocol: SMTP, Port: 995,
Secure(SSL): Yes, Error Number: 0x800CCC0F
Your server has unexpectedly terminated the connection. Possible causes for
this include server p...delete server...routing master error
I have 2 exchange servers (exch 2003) and i have to delete
one of them.
I changed all replication etc...(before we had also a 5.5
which is already removed) but when i stop the services and
try to remove the server via system manager of my second
exchange (the one that will stay) i get an error message
that my server that i want to delete is the routing master
for that group.
How can i make my other server the routing master ?
i don't have any site replication (deleted it because not
Go to routing groups > first routing group > mem...Excel error codes translations
Does anybody know where I can find a kind of dictionary for Exce
The problem is sometimes I get an error message that is not in Englis
and without error code and then looking for the solution I must kno
its equivalent in English.
Message posted from http://www.ExcelForum.com
...toolbar, date, services, errors, paste, minimized system restore doesn't work
I have a XP system that the toolbar does not show open programs, services do
not seem to load at boot, the date is off by one month, I cannot paste
anything that I copy, and system restore does not work. All of these issues
started at the same time a few days ago. Has anyone else seen this group of
errors? I am trying to resolve and do not know if it is a system update
gone bad, or if maybe it is a viruse/malware issue. Please let me know if
you had had these problems together and what you did to fix them.
There is a very good chance that you are seeing the effects of a hi...Re: Money 2004
Thanks for the suggestion. I tried unregistering/re-registering the msxml3
DLL, but still no luck. However, knowing the help file topics are local
might help with debugging this problem.
"Randy" <firstname.lastname@example.org> wrote in message news:...
> I've recently upgraded to Money 2004 Premium from 2003 Deluxe. I'm now
> finding that I can't view any help topics--I get the "Unable to load
> Click here to try again." I've tried all the suggestions posted here and
> other sites: cleared out temporary in..."File Error: Data May Be Lost" error when opening workbook saved in Mac
When I open in Excel 2007 for Windows workbook with charts saved in
Mac OS, I see the message "File Error: Data May Be Lost".
In Excel 2003 for Windows this message appears as many times as many
sheets there are in workbook.
Maybe someone knows what's the reason?
Unfortunately you haven't provided the info needed... "Mac OS" means very
little. The question is "What version of Mac Excel are you using, what file
format are the files saved as & what type of content is in the files?"
In general, what you're running into is that Excel 2003 &a...Technical error
AMEX and Discover are not being sent over to the credit card processor during
settlement. I comes up with a "TECHNICAL ERROR". Visa and MC are settling
fine. Does anyone know what the problem is?? All are setup as different
tranaction types in RMS and ALL authorize fine during the transaction process.
Your merchant account is not correctly configured for AMEX & Discover. This
is on the bank's side, not RMS.
Tiber Creek Consulting
Please DO NOT respond to me dir...CObject Private method access error
I am trying to recompile application that has been developed in VC++
6.0 with VC++2005..
While compiling, I'm getting the following error..
error C2248: 'CObject::CObject' : cannot access private member declared
in class 'CObject'
1> c:\program files\microsoft visual studio
8\vc\atlmfc\include\afx.h(553) : see declaration of 'CObject::CObject'
1> c:\program files\microsoft visual studio
8\vc\atlmfc\include\afx.h(524) : see declaration of 'CObject'
1> This diagnostic occurred in the compiler generated function
'CExcepti...Publisher says there has been a significant change to my system
I recently moved from one state to another. When I accessed MS Word for the
1st time after that, it gave me a message that it had detected significant
changes to my system. I was able to insert my Office CD & it fixed the
problem. Now I'm getting the same message when I try to access my resume on
MS Publisher. The trouble I have is that somehow Publisher isn't on my Office
CD. Is there a way to get Publisher, it says it's Publisher 2002, to work
correctly? I need to make some changes to my resume so that I can apply for
some jobs. Any help will be greatly appreciated.
P...Error in closing Outlook
Application error ciceroUIWndFrame.
The instruction at 0x7e430240 reference memory cannot be
Also unable to dial a phone using Outlook.
Take a look here
Please Reply to Newsgroup for the benefit of others
Requests for assistance by email can not and will not be acknowledged.
"Sanford Aranoff" <email@example.com> wrote in message
> Application error ciceroUIWndFrame.
> The instruction at 0x7e430240 reference me...SMTP Problem
We have excahange 2000 server which forwards mails to our
SMTP server in turn which can send mails on Internet. Some
time our excahange server doesn't ping to SMTP server and
then all mails goes to unrechable destination Queue. Then
never comes back to Internet SMTP connector Queue. We have
to start SMTP service 2 -3 times then only it moves back
to Internet SMTP connector Queue. Please help me so the
messages gets transfer to Internet SMTP connector Queue
immediately. and then it can deliver to SMTP server to
send it on Internet.
How and where did you set the forward?...Typing message error
I have an Asus Eee PC netbook which came with a Microsoft Works 2007 trial.
I'm unable to type anything on a Word document. An error message flashes
briefly at the bottom of the screen, "This modification is not allowed
because the selection is locked." I'm baffled. Is this a computer problem
or a Works problem and how can this be fixed? Thank you.
I would be surprised if any system nowadays came with a Works trial; more
likely it is an Office 2007 trial (and if it *is* Works, then you're in the
wrong discussion group). If the computer is quite new, then...Can't Erase Tapes: DPM Fails with Error ID:3308
I attempt to erase a tape and every time the DPM console crashes (sometimes
two hours into the tape erase) and there is this error:
* (000002L4) could not be erased for the following reason: (ID 3308)
* DPM service terminated unexpectedly during completion of the job. The
termination may have been caused by a system reboot. (ID 910)
I can verify that the server has not rebooted.
I'm using DPM 2007, with June Rollup, on Windows Server (x64) 2008. The
server is a Dell PowerEdge R710. The tape drive is an LTO4 in a Dell
PowerVault 124T Autoloader.
This error seems to ...Receive an error message when you try to perform any editing tasks
We have exch2003 cluster and recently we have some note book with Vista, now
when we are accessing mailbox through OWA we are getting error when we want
to edit (reply, forward) there is article from MS, we want to know does this
article also apply to exch clsuter or it is for member server. The artical is
Not sure what you mean by either exch cluster or member server, but
basically you will need to install this patch on your FE and BE
exchange servers, including your exch cluster servers. To install exch
hotfixes or patches, move...Identifying contacts, Emails, Tasks
I'm using O2003. I sometimes drag and drop stuff to delete that I
don't want to (especially contacts). Is there a field that I can add
in my table view indicating the type of item I am deleting? Basically
some type of bitmap, trext, icon saying this item is a contact, task,
email, etc. For example, I could easily sort on this field in my
deleted folder and know if I'm deleting some contacts or not.
There is already an Icon field which is included by default in most built-in
MVP - Outlook
*** Messages sent to my e-mail address...PM Transaction continuing error message #2
We are currently running GP 10 SP1 and apparently since version 8 (we
did not upgrade to 9) there has been the following error message
launching a transaction out of Smartlist, when we go to inquiry for
documents, and drill down of PMTRX & PMCHK from the JE inquiry view:
Unhandeled Script Exception:
Index 0 array of 'PM_Transaction_Inquiry_Fill' Script terminated
We ran a query for all documents that were less than 1 or greater the
8 on the PM00400 & PM30200 tables. And updated the ones to what they
needed to be. And it worked! And the message went away! But then we
...outlook.pst error message
When I attmept to open Outlook 2000 (in Windows XP) I get
an error message that the file C:Documents and
Data\Microsoft\Outlook\outlook.pst has detetected an
error. It tells me to quit all mail-enabled applications
and then use the Inbox repair tool.
I have tried to run the repair tool many times and it
always crashes before it fin9shes scanning the files.
One time it finished the scan and stated that files were
damaged and it asked if I wanted to Repair those files.
I said yes and it froze up and would not respond.
Are there any other ways ...