Category Name Mods at Runtime
Creating a template to use with basic chart but when certain Xaxis labels
contain specific values that might show in certain data sets, I'd like to
either change the font color or use the interior colorindex property.
In other words,
But when the category values are displayed - I'd like the letter b to be in
I'm already scanning the data and modifying the color of the datalabel font
and the correlated bar chart but wanted to also change the category label.
Thanks in advance...
Any chance this property is available?
You can't format axis la...How to delete Name When Printing in Memo Style
I want to customize the Memo Style for printing job in
outlook, and I do not want a name to appear at the top of
my printed item. For the security issue, I can't create
a blank or fake account (Microsoft solution for this
Can I create a new style and delete the user name field
from the top? If I can please let me know how.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without read...how do I reveerse name order last name, first name to first name, last name
I have a long database, 27k with names that I want to mail to. The
list is last name, first name. I want to do a global change to first
name, last name. I also want to add "Mr" to it. For example: the
list now is Smith, John. I want to change it to Mr. John Smith for
the entire list.
Assuming there is only one comma in each:
Note that some of the women might be offended.... 27k names, all male?
Don Smith wrote:
> I hav...Convert text to text
I have a list of funds from 2 different companies. I have to manully
type in one list, different order everyday and out of 25 about 15 are
Need help with how to fill in formula do get that automated? Any link
or article will do.
Not clear from your description what you have and what you need.
We know you have a list of funds.
What and where are you typing?
What do you mean by 15 out of 25 are present?
Gord Dibben MS Excel MVP
On Tue, 23 Nov 2010 12:10:26 -0800 (PST), BetaDocuments
>I have a list of funds from ...How do I view Pivot Table source data file and field names?
I'd like information on how you can view the name/reference for the source
data of a Pivot Table. For Example, in MS Access and Cognos Impromptu you
can go to SQL view and see where data in a Query is coming from. It's easy
to find the source of formulas in Excel, using the Audit Toolbar. I'd like a
way to quickly view the file name (whether an Excel file or external source)
and field names that were used to create the Pivot Table.
> I'd like information on how you can view the name/reference for the
> data of a Pivot Table. Fo...Select name from drop down and return associated value
I have a spreadsheet where I need to return a value which is an
alphanumerical code but the users know only the name.
In worksheet A there are details of clients. If the clients
participate in a course we are required to record the course code not
Column C is where I want the value to appear. What i would like to
occur is that the user selects from a drop down list the name of the
course but on selection the value returned is the course code.
Is this possible?
Are you saying that you want the user to select from a dropdown some
course name, but you wan...repetitive mail
i'd like to send the same e-mail to the same recipients weekly. is it possible to do this in outlook 2003
...installing driver error code 1
I have a developed a driver for a usb device. I am able to install the
device, using my driver, on XP and Vista, but not on Windows 7. When trying
to install it on Windows 7, I get "installing new hardware" then "device
driver software was not successfully installed". When I go to device manager,
and look in the details of the properties of the device, the install error
says "device instance name is invalid".
Any ideas of what does that mean and why it is working on Windows XP and
Vista but NOT Windows 7?
Any ideas how to go around it?
Can anyone tell me a easy way to fill in an area with repetitive characters
(i.e., periods) ?
I am working on a menu for a restaurant and need to fill in the space
between the end of the description of the food and the price?
Any help would be greatly appreciated!
Format/Tabs/Right alignment/dot leader
"Lorri C." <email@example.com> wrote in message
> Can anyone tell me a easy way to fill in an area with repetitive
> (i.e., periods) ?
> I am working on a menu for a restaurant and need to fi...Change Business Unit Names
Is there a way to change the Names of the CRM units? We have 4 major units,
but they have all recently changed their names, but in CRM they are still
indentified by the old names.
Biggest problem with this is that the BU's have corresponding Org Units in AD.
If you have a dev/test server you could try the following to see if it works:
- Rename the BU in the BusinessUnitBase table
- Rename the corresponding OU In Active Directory
I don't know if the names need to be kept in sync since most of the ties are
done through the SID's, but it helps for debuggin if they have the same ...Retrieve File Names in Directories
Can anyone tell me how or if it is possible to start at a particular
directory and drill down to all subdirectories and get the names of files and
the associated paths of each? I was thinking you can do this with the File
System Object within Excel VBA?? If anyone could point me to good web site
that covers this, it would be appreciated.
I basically want to start at one directory and follow all paths until no
more directories. So drill both down and accross. Hopefully I am explaining
What do you want to do with them after you get them?
At a...UDF's, XLA's and #NAME!
I initially developed some UDF's in an XLS, which was used for testing. All
was fine. An XLA was then created with these UDF's. In a new XLS, these
UDF's also work fine.
But in the original XLS used for development I removed the UDF's from the
XLS, expecting that Excel would find the UDF's in the XLA. But references
to any of these UDF's produces #NAME!. If I qualify the reference with
"NameOfXLA.xla!MyUDF()" it then works. BUT, Excel removes the
"NameOfXLA.xla!" from the formula (I guess because the name MyUDF is unique
so it's not...Errors were detected in file name.xls
Errors were detected in file name.xls, but Microsoft Excel was able to open
the file by making the repairs listed below. Save the file to make these
This error message may be followed by another error message after you
attempt to save the file: "Damage to the file was so extensive that repairs
were not possible. Excel attempted to recover your formulas and values, but
some data may have been lost or corrupted."
This error sometimes occurs when you try to open a file in Excel 2003 that
has been previously saved in an earlier version of Exc...convert from last name, first name TO first name, last name
How can I convert my contacts (as a group menaing all of them at once0 from
the last name, first name to first name last name, without having to enter
EACH cotnact and perform it almost 400 times?
Also, in what format would you suggest trying to print my contacts showing
fields name mobile, home, work phone and email address? I assume there is a
way to make used defined fields?
You'll need to create a post with enough information that others could
understand it. How are we to know which field or view you are trying to
"convert?" Be specific.
I would suggest pri...Access to the [No Display Name] window was denied. Activity Tracking
We've setup activity tracking in GP 7.5, but for any third party
products, if we deny security to one of those windows, we get the
Access to the [No Display Name] window was denied.
This works fine in GP 9.0 for the third party product. Is there anyway
to populate a lookup table or something to make it work in 7.5?
Central Service Association
...Outlook 2K3 LDAP check name problem
i have a STRANGE issue with LDAP and Outlook 2003.
Basically, if i type the first names of people in the To:
section and try to resolve (Ctrl-K or Alt-K) all of the
names at once, it wont work.
BUT it will resolve the very first name but will offer no
suggestions for the next names. I will then cancel this,
(the first name will have resolved) and when i try to
resolve the names again, it will work for the next
unresolved name (the first one was resolved remember) and
then fail on everyone after that.
so basically, in the To: box, if i type in
john;chris;peter, do CTRL-K it...setting up toolbar button to accomplish repetitive task
Operating System: Mac OS X 10.5 (Leopard)
How do you create a macro (I know, I know, macs don't do macros)-like function wherein you can select several process steps (e.g., click on format>font>strikethrough>OK) in one mouse click on a toolbar button? <br><br>Thanks.
It isn't that *Macs* don't do macros, it's that Office 2008 doesn't because
it has no support for VBA. The next release will have VBA support restored &
prior versions of Office have VBA support.
The interim alternative is Apple Script, but I d...Function that Returns Worksheet Name
I could have sworn there was a function that returns the Worksheet name.
Similar to how NOW() returns the current date and time. Does it exist? What
I'm using Excell Professional 2003
In article <E95FBC1C-3C16-43B0-AC51-C5FF11B81C9B@microsoft.com>,
"Moset" <Moset@discussions.microsoft.com> wrote:
> I could have sworn there was a function that returns the Worksheet name.
> Similar to how NOW() returns the current date and time. Does it exist? What
> is it?
&g...Repetitive sent messages
Several times I have forwarded interesting attachments of pictures and they have been sent to the receipients SEVERAL DOZEN TIMES! Very unhappy friends! Why does this happen?
I would run the inbox repair tool and send something via webmail to
determine if it is outlook or the server causing this problem
"Ron M" <rmurdock(removethis)@whidbey.com> wrote in message
> Several times I have forwarded interesting attachments of pictures and
they have been sent to the receipients SEVERAL DOZEN TIMES! Very unhappy
friend...Name a Column
Is it possible to put a name in place of the "A" at the top of the column? How do I do it?
"DaveB" <firstname.lastname@example.org> wrote in message
> Is it possible to put a name in place of the "A" at the top of the column?
How do I do it?
No, is not possible.
Place names/titles in Row 1 then select A2 and Window>Freeze Panes to keep
these in view as yoi scroll down.
Tools>Options>View. Uncheck "R...view by name
Hello, I have a customer that manages someone else's mailbox. We have it
mapped in her outlook as another mailbox in her profile and she has full
rights to it. She needed to find a particular email that was sent to someone
so she went to the sent items and viewed by "To" and typed in the person's
name. There should have been 2 messages that came up as there were 2 that
were sent to that person that day but only one shows up. If I view by date,
then the other one shows up. Now this happens occassionanly, not just this
time. Most of the time if she view's by "to" ...Filter based on named range cell
I am trying to filter a sheet based on the named cell ("TeamData) on an
alternate sheet but keep getting a debug 'Object required' at the criteria
range. The debug recognises the value in the range as when hovering it shows
the correct text on the highlighted issue.
Detailed is the code:
My_Range.AutoFilter Field:=1, Criteria1:="=" & Range("TeamData").Value
My_Range.AutoFilter Field:=...E-mail "Send To" name list
All the names in the pop-up "Send To" address list are
alpha by FIRST names, which is dumb, annoying and time
consuming. How do I switch the list to alpha by LAST
name and make that default???
...Duplicate named ranges
Is it possible to have duplicate named ranges in a
workbook? I am using Excel 2000 on a Windows 2000 system.
I can acheive creating a duplicate named range in a
workbook by doing a copy sheet into the same workbook but
I am unable to create multiple named ranges in the ame
workbook by other means. When I try to define the named
ranges I get directed to the last copy defined. Is there a
way around this?
You can have workbook names that apply to the whole workbook, and worksheet
names that only apply to that sheet and can be replicated on each sheet. To
create the lat...Ldap server name
We have no problem setting up our PCs to work with Exchange 2003 (of course)
but our macs are a little more challenging. I can not figure out what the
ldap server is for our exchange server. I have tried every configuration I
know of. You can see the GAL if you are in our main office, but if
entourage configures it automatically, the ldap server is just hpg. No one
outside of the office can see the GAL. Any help would be great!
The LDAP server will be any GC server in your AD environment. Can
external users access AD? If not that is the problem.
Kerry Murphy wrote: