2 Questions on Pivot Tables
Any assistance appriciated. (Excel 2003)
1) I have a simple Pivot table showing 6 groups with their totals and a
Oz 22 etc.
Grand Total 125
I want to Pivot Graph this data, no problems. I want however an extra line
to show the total on the Secondary Axis. I have almost got it by placing
the column in a second time as a Running Total and then as a Line on my
chart, hiding all the values until the last point.
However I would like if possible the Total as a horizontal line across the
2) I h...Any word on CRM 1.2 release date?
Has anyone heard a firm release date yet for CRM version 1.2?
And will CRM 1.2 work with SBS2003 that was just released?
"Jim" <firstname.lastname@example.org> wrote in message
> Has anyone heard a firm release date yet for CRM version 1.2?
This depends on where you are based. I've just got home
from an MS course, and we told that in Australia it will
release to the partners at the conference late next month,
and will be released to customers on 12/1/04.
It was also confirmed that it will run on SBS2003 - it
will ru...Page set up #2
I want to use the paper size of A3, but cannot find it in the paper options.
Anyone know where I can find it?
Check your printer properties and preferences. If the printers you have
installed won't handle A3 you won't have it. And you will need to
"install" something that will. Even a "PDF" file printer will do.
Alan Badgery wrote:
> I want to use the paper size of A3, but cannot find it in the paper
> options. Anyone know where I can find it?
I've just a home use computer, but the intention was to use the work book
between and home and work, w...Monitoring Exchange 2003 #2
We are planning to implement MOM 2005.
However, we are also concerned about implementing auditing for changes
made within ESM.
Will there be a tool that will allow management to know a change was
completed by a specific UserID? When a mailbox store is dismounted - who
When a change is made to the RUS - who made the change?
MOM does not have the ability to monitor this in the shipped Management
You can enable AD auditing on the domain controllers:
http://support.microsoft.com/default.aspx?scid=kb;en-us;314955&sd=tech. ...smtp addresses #2
I have 2 smtp addresses under recipient policy.
smtp: email@example.com (set as default)
These were created automatically when we migrated from exchange 5.5 to 2000.
local.domain.com is our internal domain.
domain.com is our Internet address.
I unchecked local.domain.com address, and "Apply this policy now", but it
did not remove them from each users AD account.
So I deleted the local.domain.com address, and "Apply this policy now", but
it still did not remove them from each users AD account.
We are getting NDR's b...Mail deleting from virtual inbox
When I open windows mail it automatically downloads and it deletes it from my virtual yahoo inbox, is there a way i can get it to stop deleting it or being able to place those messages back in my inbox to retrieve anywhere? also, it doesnt allow me to send messages so i cant foward them to myself!
Thanks, i appreciate ur help!
Erika Hey Erika.
I was having similar problem a while back. I remember in my webmail (optus)
there was an option at the bottom of the list of emails (delete after
download). I had to untick this box. You may have something similar, maybe in
tools?? Just be aw...Exporting emails from Outlook 2003 #2
I have a folder that contains over 500 threads on technical matters on a
I have tried to use Export to Exel but this does not transfere all the
information over including not giving all the text in the body of the email.
A similar problem is saving an email to a folder outside outlook it doesn't
show the date so you may have a huge list of items all titled but not dated
in the title
Please can anybody help?
why do you want to export the emails. What is the target/reson to export the
Share Outlook without Exchange (Vista Ready): Publi...How big is the outgoing mail messages
Is there any way to see how big mail the user are sending or receiving.
And who's sending the mail.
I have exchange 5.5 and windows 2000
...Only printing header in Windows Live Mail
My canon printer has suddenly stopped printing the email content - only the
Printing in word, excel etc not affected. Using W7 (+ Firefox if that
Any suggestions please
Does you have the same problem if you try printing from IE? WLM depends
on IE for printing services.
Take a look at this:
Print and Print Preview May Display Only Text at Top of Page
It's a similar problem for a different version but the fix may apply.
Mike - http://TechHelp.Santovec.us
"Jem" <Jem@discussions.mic...Outlook pop up windows stops outgoing mail
In the last 3 weeks I continue to get a pop up window
titled "Enter Network Password". There is a key icon and
the request: "Please type your user name and password."
It then list my
Password: (entered with asterisk showing)
I continually enter my Outlook password with Bellsouth
and click the box "Save this password in your password
list" and click "OK".
Everything then works alright and then the window pops up
again in 5 minutes. It happens over and over again.
Anybody have any ideas on how to eliminate this? I use
XP Pr...open subfolders automatically on mail entry -- not happening.
Have a problem that happens in one Outlook 2002, but not another -- so I
know there's a likely setting someplace, but can't find it. I've even stumped
my company's IT people on this one:
I download mail through several rules (and accounts); and ship them to
various subfolders off of parent folders. What I desire is to have the email
automatically open the appropriate folder -- revealing the affected subfolder
-- when new mail comes into it. In one of my Outlooks (both 2002), this does
open automatically revealing the new highlighted message. But the other do...training #2
Is there a class offered on Publisher and if so will it
ever come to Ohio? Thanks
Lots of good training articles available on the Office site.
Where in Ohio?
Mary Sauer MS MVP
"Cindy Taylor" <firstname.lastname@example.org> wrote in message
> Is there a class offered on Publisher and if so will it
> ever come to Ohio? Thanks
On Tue, 4 Jan 2005 19:06:21 -0500, "...Sent Mail items not showing up
Using Outlook 2002 w/SP2 on WinXP Pro. Unable to view
items in Sent Item folder (Outlook shows normal blank
window with "there are no items to show in this view")
even though the Item count in the lower left shows over
2600 msgs in the Sent Items folder. It keeps increasing
as new msgs are sent. Using the standard view, all
standard columns, with NO Filter set.
Anybody seen this before? Any ideas?
...mail merge cannot continue
I have been using mail merge in Publisher 2000 on Windows
XP. But it suddenly started refusing to work, giving the
message "mail merge cannot continue". I have tried
reinstalling and uninstalling things I had done recently,
to no avail.
Did you have to relink to your database? If so, try changing your selection
in the checkbox for "First row of data contains column headers".
"Margaret" <email@example.com> wrote in message
> I have been using mail merge in Publisher 2000 on Windows
> XP. But it...Event ID c0072030 #2
We have an Active Directory Organizational that contain
all of our contacts. I have run the delegation of control
wizard and given a user full control over the contacts OU.
When I log on with that users account and try to update to
add an SMTP address to a contact I receive the following
There is no such object on the server
...Outlook not opening #2
I recently installed Outlook. When I try to open it, I get
the error message "Outlook requires Outlook Express 4.01
or greater". I do have OE 5.0 installed. Why am I getting
...List Boxes #2
Can someone tell me how to correct the following code so that both
columns in the listbox will be updated? Only the first column
ReDim MyArray(mycount, 1)
usrGLDist.lstOutput.ColumnCount = 2
For i = 0 To rst.Count - 1
MyArray(i, 0) = rst.Value("descr")
MyArray(i, 1) = rst.Value("pcamt")
usrGLDist.lstOutput.List() = MyArray
Richard wrote :
> Can someone tell me how to correct the following code so that both
> columns in the listbox will be updated? Only the first col...How can I line up 2 columns with similar information?
I have 2 columns with names in each and I'd like to line them up next to each
I think we'll need more information, Kathy. I don't understand what you're
trying to do. Can you give exactly what's up?
"Kathy" <Kathy@discussions.microsoft.com> wrote in message
>I have 2 columns with names in each and I'd like to line them up next to
Column A has employee number, Column B has the same employee numbers but has
addi...Lost Product Key #2
Wanted to install my publisher deluxe 2002 onto my new computer. I've lost my
product key. What can I do? How do I do it?
Whistle Britches wrote:
> Wanted to install my publisher deluxe 2002 onto my new
> computer. I've lost my product key. What can I do? How do
> I do it?
Have a look at the following KB article:
(823570) How to Obtain a New Product Key
for Office Program Setup
return e-mail disabled
...RMS POS 2.0 SP1 fails to install
We are running RMS 2.0, and when I tried to install POS SP1 I get the
following error" The expected version of the product was not found on your
system" I have searched kb and found nothing that may address this.
Any ideas would be appreciated.
Sounds like you got the wrong service pack. POS is a different product. You
need RMS 2.0 Service Pack 1.
"Davidjc52" <Davidjc52@discussions.microsoft.com> wrote in message
> We are running RMS 2.0, and when I tried to install POS SP1 I get the
&g...How do I make a particular column required in Excel? #2
Our NPO is creating a reimbursement chart in Excel. We're trying to make it
so that if employees do not fill in one particular column entitled
"Projects," they will get an error or will be unable to have a final sum
Is there any way I can make this particular column required so that if it is
not filled in, the chart will not complete properly?
Thank you in advance for any advice or help--I'm a bit of a novice to this!
...help with lookup formula (sheet 2, not a double post)
I need to make a formula using a lookup. The first spreadsheet is a
inventory (ALO INVENTORY JP). The second (P&G 103) is a chart tha
tells number of gallons of alcohol per foot/inch/fraction.
On ALO INVENTORY JP I insert the # of feet, inches, and the fraction i
cells R5 and T5. I want these numbers to lookup the number of gallon
off of the P&G 103 worksheet.
For example: P&G 103 (on inventory sheet) is 26ft 4 1/2 inches, i
should look-up to be 34572 gal. for the 26'4" and 55 gal. for the 1/2"
These two numbers should be added together and multiplied by the numbe
...Move / Migrate Mail
I currently have my Exchange server hosted off site.
I am looking to move this in house, of course I don't own the hardware the
server is currently on.
So I will be building a new server.
The current server (hosted) is in its own domain - I did not make this but I
have to support it-, I have duplicate accounts for email, plus some only
email accounts. I am looking for suggestions to accomplish this task.
My idea was to add all the user accounts that are currently 'email only' to
my domain so all my accounts match.... Make my Exchange server and
mailboxes. Then should I u...deleting mail on exit not working
hey guys im using outlook 2002 and I have selected empty deleted items
folder upon exiting which works until i restart my computer. I have to
slect this option everytime i restart my computer because the option
keeps unchecking itself. Any body knows how to fix this problem
thanks in advance
Am 6 Sep 2005 12:04:27 -0700 schrieb firstname.lastname@example.org:
> hey guys im using outlook 2002 and I have selected empty deleted items
> folder upon exiting which works until i restart my computer. I have to
> slect this option everytime i restart my computer because the option
> keeps uncheck...new blank doc
I some how corrupted my blank doc. When I go to file and open. I get a blank
doc with 3 cloums saying next record. How can I get my blank doc back so
that I can do my work?
While this newsgroup is for Microsoft .NET (dotnet) questions, you should
locate the hidden system file called "normal.dot" and delete it.
"new blank doc" <email@example.com> wrote in message
>I some how corrupted my blank doc. When I go to file and open. I get a