[mso] Re: Excel 2000 Personal.xls
- From: "Linda F. Johnson" <linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Wed, 20 Dec 2006 18:24:02 -0500
#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
*************************************************************
Other related posts:
