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" <email@example.com> 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: firstname.lastname@example.org (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...How to make Access 2007 Navigation pane invisible?
I have tried the Access Options. | Current Database | Navigation, uncheck
Display Navigation Pane, and the vertical "Navigation Pane" still displays
in a compiled .ade.
Something else yet?
"Dean Slindee" <email@example.com> wrote in message
>I have tried the Access Options. | Current Database | Navigation, uncheck
>Display Navigation Pane, and the vertical "Navigation Pane" still displays
>in a compiled .ade.
> Something else yet?
> Dean Slinde...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...Writing to word 2007
I have a 2003 access database that writes data to text fields in a 2003 word
document, no problems,
I have now upgraded the database to 2007, and the same code although it
appears to run ok, does not actually update the word document fields, i also
tried converting the word document from 2003 to 2007. I data transfer using
code from within access
So no error message; it just doesn't seem top update, right. See this:
I do it with docvariables. Are you using docvariables? If so, read this:
http://w...Outlook 2007: "Cannot save free/busy information"
I have been getting the error message "Cannot save free/busy information"
from Outlook frequently these days. It started when we changed our
configuration from connecting to an Exchange server on the LAN to using a
proxy Exchange server that forwards (I imagine) to another Exchange server
on a different LAN.
I have my profile configured to deliver to a local PST file.
It seems that Outlook does successfully update free/busy info on the server
sometimes; the error message appears fairly randomly - e.g. sometimes when I
delete a meeting request, but not every time.
An...Cannot open Money Deluxe 2007
New laptop, successfully using Money, then now I cannot open it. Windows
keeps shutting it down. Tried running as admin. Tried uninstalling, then
In microsoft.public.money, Karen wrote:
>New laptop, successfully using Money, then now I cannot open it. Windows
>keeps shutting it down. Tried running as admin. Tried uninstalling, then
What OS? Is there an error message?
Were you successfully using Money on that new laptop? Did the
problem occur recently? You might want to consider a system restore
point from before the pr...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, "...Using Word 2003 in Vista: Opening dictionary shuts down Word
This is a problem in Vista; it did not occur when I used Word 2003 in XP.
Whenever I try to open the dictionary in Word 2003, either by clicking its
icon, or hitting Alt+click over a word, Word shuts down.
Vista Business, Service Pack 2
Thinkpad T400, Intel Core 2 Duo CPU, 3GB RAM
...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
...in creating a pie chart in excel 2007
How many rows or columns of data can the pie chart plot
I once tried 360 cells and got a wonderful Moiré pattern
Why not just experiment with 1, 2, 3 dozen and see for yourself if the
result is acceptable ?
Microsoft Excel MVP
"bsalohcin" <email@example.com> wrote in message
> How many rows or columns of data can the pie chart plot
According to MS:-
Data series in one chart 255 (max limit)
Data points in a...One Record Per Page Printing-Access 2007
Report for daily appointments for senior transportation drivers. Report is
grouped by Driver. Keep together is selected.
Detail band: Keep together-Yes; Force New Page-Before Section; Can
Grow-Yes; Can Shrink-Yes
Goal: Report generated so each driver has his/her own appointments.
Orientation: Landscape, paper size 8.5 x 14, column width: 13.5729"; column
When previewing in Print Preview one record per page is appearing rather
than all appointments for a driver for a given date. I have the bands as
narrow as I can make them. I am missing somethi...cannot get BCM to work on Office Enterprise 2007 and Windows 7
I have Windows 7 and Office enterprise 2007 and tried to install BCM 2007 and
got it installed then opened Outlook and said it could not setup database. Is
BCM 2007 compatible with Enterprise and Windows 7. Is there a work around?
...MFC Registry Access in Automation Servers (EXE)
I have written a MFC server application (MFC automation server). Some
configuration settings are saved with WriteProfileInt /WriteProfileString to
the registry. I used SetRegistryKey("Mycompany") for the registry path. The
application works fine under different users.
Now this application is started as embedded server via my ASP code from the
IIS. The machine is a Windows 2003 Web Edition Server.
For this case the DCOM and IIS settings uses a predefined user for the ASP
code and the COM server. If I start the app per hand now under this user
everything is going well. But if the app ...center text when conditional format applied
Textbox control on Access 2007 form lost its centered alignment when
conditional formatting is applied. This did not happen in previous versions
I tried using format painter to apply conditional formats from a control
created in an earlier version, but this failed. The control created in the
earlier version then lost it's centering after saving in Access 2007.
Interesting. I tried to replicate this behaviour but failed, it all worked
as it should.
Try revisiting your form after applying the conditional formatting and
resetting the text box to center text.