Changing the chart name
Where/how can I change the name of a chart?
When my chart is referenced in macro code, it is referred to as "Chart 2",
i.e. ActiveSheet.ChartObjects("Chart 2").Activate
I want to be able to change the name to something more meaningful, but I
want to do it directly on the chart itself and not in the macro code.
Thanks in advance
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
"Sarah (OGI)" <...Change sorting and grouping
Report sorts by: Rep Name with Header and Footer
Type with Header and Footer
I need to add Group as the first sort before Rep Name but can't figure out
how to do this.
B Moody wrote:
>Report sorts by: Rep Name with Header and Footer
> Type with Header and Footer
> Date (without)
>I need to add Group as the first sort before Rep Name but can't figure out
>how to do this.
Open the report in design view. Use the View - Sort...can't save changes to workbook; ready only
We use and Microsoft Excel Workbook as our database and I am the primary
person that makes changes and those changes are saved on the other two
people's copies who work in the office.
This morning when I tried to save changes it would not let me and changed my
copy and their copies of the workbook to a [read only] [shared]
[compatibility mode] database.xls
This when I clicked save a box came up stating that there over 265 persons
using the database at this time. Which can't be possible since we only have 3
people in our office who use it only a daily basis.
It was ...Word 2007-Pinning documents to most recent list
I've pinned several documents to my most recent documents list but they don't
always show. For example, I have about 5 documents that I have pinned and
I'm showing 20 new documents when I click the Office button in Word.
If I have worked recently with 25 or 30 documents, but not one of the 5 that
are pinned, then the most recent 20 show, and that list doesn't always
include the 5 that are pinned.
Do I have a setting wrong somewhere? Or is this a known issue?
If you are showing 20 documents in the list and you have worked with 20
documents other ...Can Excel 2007 link with Outlook 2007
I have a list of companies names that I need to add the addresses to. I don't
want them to be on the same worksheet. I will need to add compaines to the
list from time to time. Also Is it possible to link these addresses with
...Can I stop formatting changes from appearing in "track changes"?
Operating System: Mac OS X 10.6 (Snow Leopard)
Under track changes preferences, I have "none" selected, yet formatting changes still show up when I chose to display the changes in balloons. I can accept most of the formatting changes in order to eliminate the balloons, but sometimes I click to "accept" 10 or 20 times, but the balloon won't go away. <br><br>I realize that this is only a problem with balloons, but my pagination gets messed up if I don't use balloons.
Yes: Turn off "Keep track of f...Outlook 2007 & CRM Outlook client (V3C), problem tracking appointm
I'm currently using Outlook 2007 with the latest CRM Outlook client (V3C).
I have no problem adding emails to CRM with Outlook, but when I try to create
a new appointment, the CRM section does not appear in the ribbon. After
creating the appointment, if I highlight it in the calendar view and click on
the "Track in CRM" button on the Outlook toolbar, I get the following message
"This item type is not valid for promotion to Microsoft CRM". If I go back
in my calendar to an earlier appointment that was created when I was using
Outlook 2003, then everythi...ACC2000: change string to int
I have a customer number that is a string, but I need to change it to an
integer variable. Assigning: iCust = sCust does not work. (I just want
to drop leading zeroes in the string. It can stay a string if that's
Is there a function to convert string to int? I could not find one in
Access help. String() seems to convert a numeric to a string data type.
If you want to find Help on these types of functions, first open any module
and then open Help.
Microsoft Access MVP
If I have helped you, please help me by donat...Exchange 2007 SP2 DEPLOYMENT
our oragnization is planning to deply Exchange 2007 SP2 in our oragnization
, is there any deployment precaution concernning SCR and SCR CLUSTERING .
Absolutely, there is. There's a document in TechNet describing how you must
apply SP2 to a CCR cluster, and there's information there about the required
AD preparation before you install SP2.
Ed Crowley MVP
"There are seldom good technological solutions to behavioral problems."
"Ahmedgtech" <Ahmedgtech@discussions.microsoft.com> wrote in message
news:40C2...Warning: Money 2007 Deluxe
I thought I would try 007 out and so downloaded it. It looks very much the
same as 2006 but it may have been faster. The new simple budget thing is
pretty stupid, as is the hype MSN story about it. Hasn't anyone ever heard of
'pay yourself first' budgeting?? I digress.
I left the program and tried to start it up again. It wants a password??? I
don't use a password. The file it was trying to open was at the end of a very
long pathname so I don't know what it was trying to open, but have to assume
it was the one that was just converted from 006. But I don't use a p...How do I change my "Personal Contacts" to just Contacts?
My computer crashed but not before I saved my Outlook folder. The problem is
how do I import all of the data (emails, contacts, calendar) into the right
places? The old was 2003; the new is 2007. As of now, the old "Outlook"
folder is sitting on my new Desktop, which probably doesn't make the most
sense. The main issue is that all of my contacts are listed as "Personal
Contacts" when I really want to make them just "Contacts" in general and
create a subset of truly personal contacts. Thanks.
> My computer cra...How can i change chart data point format based on value?
I have a simple column chart with a single data series. I would like to
change the color of an individual data point column depending on value.
Thanks very much.
You want to make a conditional chart:
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
"Harold96" <Harold96@discussions.microsoft.com> wrote in message
>I have a simple column chart with a single data series. I would...Macro to delete an entire row with cells missing a specific chartacter #2
This is the script I am using to remove "IS"
Dim rng As Range
Dim what As String
what = "IS"
Set rng = ActiveSheet.UsedRange.Find(what)
If rng Is Nothing Then
So...my programming experience is a tiny bit limited, not sure how t
delete anything missing the IS as opposed to containing the IS.
understand in theory but my knowledge of syntax is the limiter.
Harald Staff Wrote:
> Hi Asf
> This is far more useful if you figure it out yourself, since you'r
> pr...Retrieving deleted e-mails
A former employee deleted their e-mails before they
left. Is there any way to retrieve these e-mails?
Thanks for your time!
In the future just a suggestion put all users PST files on
the network drive and back them up nightly.
The only thing to do is look in the deleted folder if its
not there it is likely gone.
If its really important you can try your system admin that
runs the email server to see if they have anything cached.
>A former employee deleted their e-mails before they
>left. Is there any way to retrieve...Very Large Array
I need to hold and manipulate a very large number of floating point numbers
(300 M) in a temporary 2D array. What is the best way to allocate storage
for such a monster?
>I need to hold and manipulate a very large number of floating point numbers
>(300 M) in a temporary 2D array. What is the best way to allocate storage
>for such a monster?
If it all has to be in memory you're probably going to need to go to a
64-bit OS to handle that amount of contiguous memory in your process.
For anything else I think you'll need to implement some chunking
...text wrapping #6
How do I get text to wrap around a gallery object?
The same way as any wrapping. What problem are you having? Select the object,
Arrange, Order, bring to the front (alt+F6). If you have a border around your
publication, send it to the back first. (alt+shift+F6).
"rita alford" <rita firstname.lastname@example.org> wrote in message
> How do I get text to wrap around a gallery object?
...Deleting transactions #2
Help! We had problems with one of our registers and we had to replace the PC
that we were using and and when we finally got all ready to operate we lost
everything that we had rung in (which we re-entered later) but now when we
run a detailed sales report for that day it shows all of the sales that we
cannot see in the journal but they show on the report, I want to delete them
but there is not a batch for those transactions only the transaction # and I
do not want to delete all of the transactions just the ones that are
incorrect for that day. I hope someone can help
You can v...cannot change part of a merged cell
This is the error a user receives when he tries to copy one cell into
another made up of 3 merged cells.
Sometimes it works and other times it doesn't.
Is this a fluke?
Copying one cell to a merge of three cells should work.
Are you "sure" it is only one cell that is being copied each time?
Maybe "sometimes" it is one cell and "other times" more than one.
Gord Dibben Excel MVP
On Tue, 8 Jun 2004 14:02:57 -0400, "Dominique Schroeder"
>This is the error a user receives when he...money 2007 in vista
is money 2007 compatible in vista i had laptop die so bought new one with
vista i installed money in computer it work for about one week now it says
problem with program i reinstalled same thing it wont start
In microsoft.public.money, eric wrote:
>is money 2007 compatible in vista i had laptop die so bought new one with
>vista i installed money in computer it work for about one week now it says
>problem with program i reinstalled same thing it wont start
Be sure that your Money and backup files are moved to a spot that
you will have full privileges to, such as within the use...Exchange 2007 and sharepoint1
I ahve installed Exchange 2007 beta 2 on my 64 bit HP server. Everything
instlaled correctly and i could access the OWA site. I decided to install
sharepoint and when i did it looks as though sharepoint put IIS in 32 bit
mode, and now my OWA site no longer works. Is it possible to run sharepoint
and Exchange with OWA on the same box?
I reinstalled .NET 2.0 and ran a cscript command to put IIS back to 64 bit
mode, i am restarting now so hopefully this will fix the issue and i can
continue on testing.
On Wed, 2 Aug 2006 10:08:02 -0700, skip
<email@example.com....Deleted Accounts still generating Failed Delivery Reports
Here is a strange one for you:
I send an email to firstname.lastname@example.org and it gets there and thats it.
I send a calender invitation to the same mailbox and it gets there. But then
I get a failed delivery report for former employees who used to use belong
to a Distribution list with the same name. I used to belong to that
distribution list and I do not recieve the inivitation. I am not really sure
if the failed delivery report is because of the Distribution list or because
the old users used to use the mailbox.
This happens from any machine using Outlook.
Needless to say those users are long gon...Change pivot chart options
Is it possible to modify fields through VB on pivotcharts? For instance I
have a chart that shows sales per date. And I'd like to use the same chart
to show sales by month or sales by week without the user having to move
things around themselves. I can easily set up 2 different Pivotcharts but
that seems redundant if they use the exact same layout and data.
...Change system message
When you have a combo box where you must choose something from a list and the
list to list property is set to Yes the message that comes up is "The text
you entered isn't an item in the list. Select an item from the list, or
enter text that matches one of the listed items" I would like to personalize
that message based on the control (this so I can change the message depending
on the control - different control different message). Is there a way to do
Sarah, use something like this in the NotInList event for the combobox:
Private Sub Combo10_NotInList(Ne...OWA on Exchange 2007 not working
I have installed Exchange 2007 EE and moved my mailbox. I've also created
the OWA Virtural Directory via Power Shell.
To access my mailbox via OWA I keyed"
I've received the logon screen for OWA and entered my userid and password.
When I click the Logon button I get the following message:
Page not found
HTTP Error 404 - File or directory not found.
Internet Information Services (IIS)
Does anyone know why or have I may have missed trying to configure OWA in
Exchange 2007 EE? I've created OWA under the "Default Web Site".
Wh...changing columns in the select names dialog box
Outlook 2003 using Microsoft Exchange Server.
1) Is it possible to change which columns display and in what order in the
"select columns" dialog box?
2) I have found that I can remove a column by dragging and sliding a column
to the left against the next column on the left. Unfortunately I have
removed some columns that I would like to see. How do I get the columns to
2) That's a tricky one! It took a couple of minutes for me to figure =
out. Position your mouse pointer exactly over the divider on the left =
side of the colu...