Referring to cells by range names #7
no change. but i appreciate the continued interest
rllane47's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1647
View this thread: http://www.excelforum.com/showthread.php?threadid=27830
It is not clear to me what you tried, what did work and what didn't.
I tested my answer:
Space after (Q5)
Microsoft MVP - Excel
"rllane47" <email@example.com> w...503 Error, No Recipient
I'm the IT Guy for a small company with about 50 computers. One computer
is having Outlook Problems. The user can receive emails fine, but is
unable to send, getting the message 503, No Recipient, even though it's
a valid address. I've tried doing several things to fix, but haven't
Here's what I tried in various combinations.
-Set the Outgoing Server to Require Authentication while using the same
settings as the incoming mail server
-Changed the Outgoing Server from 25 to 465
-Cleared internet settings and reset web/sercurity settings back to
I ...AVERAGE function returns #DIV/0! error
I used AVERAGE function in my spreasheet and received #DIV/0! error from it.
Is there a safe proof way to omit the invalid values out of the average
Try this. I assumed your range was A1:A10, change this to fit your data.
Enter this formula by using CTRL+SHIFT+ENTER as it is an array formula:
> I used AVERAGE function in my spreasheet and received #DIV/0! error from it.
> Is there a safe proof way to omit the invalid values out of the average
=IF(COU...CRM 4 and SQL upgrade
I have a CRM 3 installation on a SQL 2000 box which is also the CRM app
Planning for the CRM 4 upgrade, I have a new physical server with SQL 2005
What is my most efficient upgrade path?
I think you can do the following:
1. Move the CRM 3.0 database to SQL 2005.
2. Point the CRM 3.0 application to the new database server. (There's
documentations on how to move database to a new server on the
3. Install/Upgrade CRM 3.0 to CRM 4.0 on the CRM 3.0 application
I think this is the fastest and easiest in my opinion.
Darren Liu, Microsof...Pivot Tables #4
When I double click to drill down to the supporting data
in a pivot table, the data is displayed on a new tab
within the workbook. Then to close that data, I have to
delete the tab.
1) Is there a faster way to view then close the data
without having to delete a tab every time?
2) If I leave the new sheet open, is it linked to the
pivot table? In other words, if I refresh the pivot
table, will the data on the new sheet be automatically
refreshed as well?
#1. I don't think so. But maybe you could apply Data|filter|autofilter to the
original da...Error message #17
Been using Money for years currently have Money 2004 Financial Suite. For no
reason today when signing on it opens up but dispalys a "Cannot perform this
operation" this pops up several times. Money does eventually open but when
you try to move about in it it comes up again with same error message enen
when i try to shut down.
I have tried reinstslling and repairing but get the same message.
ANy ideas please
"Dale Holden" <firstname.lastname@example.org> wrote in message
news:gqxod.53961$Y7.email@example.com...Outlook memory error: 0x3ff6343a
I keep having an error message pop up that states the
Instruction at 0x3ff6343a referenced memory at 0x00000000.
The memory could not be "read".
Click on OK to terminate the program.
Click on CANCEL to debug.
Both options end with having to close out the program.
I've looked for updates, I've used my original CDs
to "repair" the problem, rebooted, etc. and nothing seems
Any helpful suggestions greatly appreciated. Thanks.
...Out of Memory #4
I have an application that is used by over 8000 users worldwide. There
are several that are reporting an "out of memory" problem using one of
the functions in the tool. One user just received a brand new laptop
(T41) and is now encountering this error. It was working on their old
laptop. The function that they are trying to run when they get this
problem opens up another excel spreadsheet and then selects sheets from
the first spreadsheet and then copies it into the second spreadsheet.
It goes through a loop and does this for each sheet. It is only
copying the values and forma...MSIMN causing MSOE.dll error
When I access View/Go To/News I get an error window saying
that MSIMN.exe has caused an invalid page error in
MSOE.dll and so I can no longer access my newsgroups.
I've reinstalled Outlook 2000 (via reinstall of Office
2000 Premium) but it is still happening.
A search of the Knowledgebase turned up this issue only
with XP; I'm running Win98, Second Edition OEM.
Had so many problems with OE 5 I upgraded to Outlook and
life has been good...until now.
Advice, suggestions, all welcome.
having trouble finding the proper spreadsheet for windowsXP...I HAVE A XLS FILE TO OPEN, anyone used a spreadsheet, that could direct me? Thank you
Windows XP is an operating system. You also need to have a version of
Excel as well.
Norman Harker MVP (Excel)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
"rick" <firstname.lastname@example.org> wrote in message
> having trouble finding the prop...error creating an If simple statement
I am getting the following error, and I dont know why
"The expression you entered has a function containing the wrong number
Past 0-30 days: IIf([proj_ship_date]-[request_date]>=0 and
Any ideas??? I am sure I am missing something...
Thanks in advance!
Thank you very much to both of u. That did it :-)
...2007 print merge 4 postcards/4 different addresses per page
I have read the previous posts regarding this issue. I cannot resolve my
I have created a 1/4 page postcard. Information on page one and successfully
merged addresses on page two. I only have one postcard on my screen and as I
scroll through, I see all the correct information in the merge.
I am having trouble printing the merge. I want 4 postcards on one 8 1/2x11
piece of cardstock. One side with the same information and the other side
with four different addresses from my merge. I am getting side one with
information and side two with four duplicated addresses. The second pi...Why is it called Windows 7
Just curious. Why was Windows 7 called "7"?
The year is not ending in a 7.
They already used 95 and 98.
I would have expected Windows 10 or 2010 (as in the year 2010)
Why the "7" ????
Or is it like this
Win3.x = 1
Win 95 = 2
Win 98 = 3
Win ME = 4
Win XP = 5
Vista = 6
Win 7 = 7
Curious minds want to know !!!!
> Just curious. Why was Windows 7 called "7"?
> Why the "7"...delivery restrictions #4
I have a mailbox that is used only to receive fax attachemnts emails from a
service that a phone company provides us.
I want to allow only emails coming from this domain
(*@voicemail.telepacific.net) to be allowed in this mailbox.
How can I chieve this? The delivery restrictions area allows only specifying
internal addresses but the address I want to allow is external.
On Thu, 10 Aug 2006 19:28:32 -0700, "Perecli Manole"
>I have a mailbox that is used only to receive fax attachemnts emails from a
>service that a phone...server Error in '/' Application #6
I am using a server farm with a 2 server scenario---1 is the CRM server 3.0
and the other is the SQL ---I got this error when i logged onto the website
on my crm server
server Error in '/' Application: An errir has occurred while establishing a
connection to the server. When connecting to SQK server 2005, this failure
may be caused by the fact that under the default settings SQL Server does not
allow remote connections. (provider: Named Pipes Provider, error:40 - could
not open connection to SQL server "
[SqlException (0x80131904): An error has oc...Error cannot access file?!?
Network connection lost? AHHHHH!
I've been getting this error in my Access project and now none of my
VBA code will work on any of my forms! It started when I closed my
project down on my computer and went over to another computer to keep
working on it. Now whenever I try to do anything in my project that
uses VBA code (for example, click a button), I get an error that says
"Error cannot access file. Network connection may be lost." My code is
still there, but it just won't run! I even tried cutting the code out
and repasting it to no avail. Any help here is sincerely apprec...Error 4.4.7 -
We are not able to deliver mail from our Exchange 2003
server (part of SBS) to certain domain names including
hotmail.com, microsoft.com and msn.com. Here is the
messages that we get.
First message from Exchange..
This is an automatically generated Delivery Status
THIS IS A WARNING MESSAGE ONLY.
YOU DO NOT NEED TO RESEND YOUR MESSAGE.
Delivery to the following recipients has been delayed.
Contents of attached text message (ATT04044.txt.) sample.
Final-Recipient: rfc822;Gary.Megson@fds...please help #4
Please guys I really need some help with this, I'm at my witts end.
We are using sbs server 2000 with exchange. If and email is sent to one of
our users say email@example.com with an other address in either the to/
cc/bbc fields, say firstname.lastname@example.org. Exchange is routing the
same email from the orgianator (spoofed) to the second address. so that the
other address recieves two copies as if from the original sender, but it
your servers that are send it out.
Now I'm asssuming this is a relay problem, but can not find any why of
Your help would be greatly ap..."already logged in" error
A valid user ID gets the message saying "Your attempt to login to the server
failed because the user ID you entered is already logged in. Remove the
login record from the server and attempt to login again".
The ACTIVITY table is empty, and we have run the DELETE SY00800, DEX_LOCK,
etc. scripts. Any other suggestions? Could it be the different VM
environment we’re running now, SQL 2000 on Windows 2000, instead of SQL 7
under Windows NT 4.0?
It always comes down to your ODBC. Check your ODBC settings to see where
it's currently...Windows 7 problem
I have a block of code in VB 2008 application which works fine on XP and
doesn't work on Windows 7 Ultimate:
'strSourse contains the full path to the file located on the server
If Not (System.IO.File.Exists(strSourse & "\InitialData.txt")) = True Then
MsgBox("InitialData file on the Server was not found. Report to your
Administrator", vbCritical + vbOKOnly, "File not found")
file_reader = New System.IO.StreamReader(strSourse & "\InitialData.txt")
tmpstr = file_reader.ReadToEnd()
I get the following error when attempting to send to a particular DL.
A configuration error in the e-mail system caused the message to bounce
between two servers or to be forwarded between two recipients. Contact your
How do I check the possibility of looping?
Do the users in the DL have forwarding turned on within their mail
properties in AD?
"pscottlee" <email@example.com> wrote in message
>I get the following error when attempting to send to a particu...Button Error
I have copied the code for this button.
The purpose of the button is to save the excel sheet at a specific location,
and to save it. I want a prompt box to appear, which asks what name the user
wants to save it as. Usually this name will be the date.
I am getting this message:
Message: Run time error: '424'
Debug = MyFileName = "MyName" & UserForm1.TextBox1 & ".xls" 'Create the
Private Sub CommandButton1_C...10.1.4 can't find an installation???
I have Office X SR-1 installed, and whenever I try to upgrade to the 10.1.4
(Exchange update), the installer fails telling me it can't find a valid
installation to upgrade. Office is located in the Applications folder of my
hard drive and is a legal copy, so I don't know why it won't install?
Thanks in advance!
On 10/3/03 8:35 PM, in article BBA3B855.28Efirstname.lastname@example.org,
"Mailinglists" <email@example.com> wrote:
> I have Office X SR-1 installed, and whenever I try to upgrade to the 10.1.4
> (Exchange update), the installer fails tel...column width #4
I thought it would be much easier but I can't set column widths from VB
After lot of trouble I find out that ColumnWidth is not what I need, i
sets width in characters not in pixels. How can I set width in pixels
I need full synta
AFAIK the width property is read-only. So you can only use ColumnWidth
> I thought it would be much easier but I can't set column widths from
> VB. After lot of trouble I find out that ColumnWidth is not what I
> need, it sets width in characters not in pix...templates #4
template won't come up after download, a validation succuessful screen
appears and I can't find downloads>?
Why don't you give us more details, what template are you downloading and
from where, exactly - give us the entire url.
If this helps, please click the Yes button.
> template won't come up after download, a validation succuessful screen
> appears and I can't find downloads>?