[mso] Re: Excel 2000 Personal.xls
- From: "Robert Carneal" <carnealre@xxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Wed, 20 Dec 2006 18:09:29 -0600
Linda- I am not referring to ranges, at least not intentionally. Just the
cell I reference to. I am away from my "Excel" computer, but when I get
home, I will copy it and post it. Maybe someone will get a chance to see an
obvious error; I think that is all it is. I am sure missing it.
Thank you.
Robert
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx]On Behalf Of
Linda F. Johnson
Sent: 2006-12-20 17:24
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Excel 2000 Personal.xls
#NAME? means that Excel doesn't recognize the name of a range or a function
.... Is it possible the formula you are storing in personal.xls refers to a
range name that is not in personal.xls? If your formula refers to a range
name, then that name must exist either in the open workbook or in
personal.xls or you will get this error
Linda F. Johnson
Linda's Computer Stop
Author, MOS: Excel 2003 Study Guide, published by John Wiley and Sons
http://personal-computer-tutor.com
I have written a function that while I have Personal.xls open, it works in
that spreadsheet. When I close it, hide it; I thought it that function was
supposed to be available to *all* sheets? So far, that is not the case. When
I try to use the function in another sheet, I get #NAME? as result.
I checked the Microsoft Knowledge Base, and it suggested I change my
security level to "Low." That bothers me, as I sometimes have to open
unknown email for the company to do volunteer work for. Is there another way
to make a function available to every workbook I open, but still maintain
good security settings?
Thanks.
Robert
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, visit the group's homepage and use the
dropdown menu at the top. This will allow you to unsubscribe your email
address or change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
If you are using Outlook and you see a lot of unnecessary code in your email
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, visit the group's homepage and use the dropdown
menu at the top. This will allow you to unsubscribe your email address or
change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
If you are using Outlook and you see a lot of unnecessary code in your email
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************
Other related posts:
