routing issue #2
we have two routers,
one is attached to an ISA server which is used mainly for the internet
one is attached to the exchange server which is used solely for email
the exchange server is sending mail throo the ISA router server - how can i
make it use the
exchange router ? - the IP of the ISA router is showing in the email headers
I presume the default gateway of the Exchange server is the ISA router?
Therefore it will always route through it.
This is all theory, as I haven't got the time to test it at the moment:
Add another IP to your Exchange server, which DFG is the r...chart area line missing in one pace (with picture)
Can anyone tell me why there's a piece of line in the chart area border
missing? I checked, and there is no object floating over it.
If you change the size of the chart area, does the missing postion stay the
if you change the backgrond color of the chart, what do you see?
If you move the chart area in the chart doc, what do you see?
If you regenerate the chart what do you get?
In other words, I don't know what causes it.
"Dave R." wrote:
> Can anyone...Create a list with multiple criteria
I have a data base with 1,000's of addresses w/zipcodes (Sheet 1 columns A to
E, E being zipcodes). After setting a base address I get all of the zipcodes
within a given radius (in this case 70 zipcodes), listed in Sheet 2, Column
A. Next, I use COUNTIF (in column B) to find how many addresses are in each
zipcode, in this example there are 46 addresses within the 70 zipcodes. What
I want to do is create a list in sheet three that will list each with the
data from Sheet 1 columns A to E).
Any help would be appreciated.
...Deactivating an embedded chart
Is it possible to deactivate an embedded chart (chart in a worksheet,
not a chartsheet).
I have an embedded chart that has a large data source range (about
10,000 cells) and a VBA macro that performs some calculations and
inputs the results into these cells, but the chart updates in realtime
and it slows the macro down quite a lot.
I have read that the following code could be used if the chart is in
its own chartsheet:
Private Sub Chart_Deactivate
But my chart is embedded, so how could I deactivate/reactivate it?
Alternatively, I though...Symbols in Excel 2007 Chart
Hello. I would like to use the greek mu symbol in an Excel 2007
histogram. I am able to convert the "m" into the proper "mu" symbol
in the spreadsheet itself but this is not reflected in the resulting
graphic. I need for my X axis label to be represented by the proper
greek letter, not m. Does anyone know how to fix this issue?
Thank you in advance.
In many fonts, holding Alt while typing 0181 on the numeric keypad produces
�. This means you don't have to change the font for some of the characters
in a text element (and many tex...Combining multiple Stacked Charts
I have 3 scenarios with info on Asset A and Asset B for 10 years. I can
create stack charts for each scenario independently, but can not figure out
how to combine all 3 onto 1 chart across multiple years.
x axis is year and each year should have 3 stacked lines Y Axis should be
total value of both Assets
Any help appreciated
Does this help?
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
"JANeyer" <...=?iso-8859-1?Q?=22microsoft_office_document_imaging=22_documents=3F?= #2
Is there a program available for Mac that can
read "microsoft office document imaging" documents?
I have a number of email attachements sent to me
with "filename.mdi" that I need to open
Can they be opened on a Mac running OS X?
...Cascading Combo for Chart Source
I have found some examples of how to use a combo to set the data
source of an excel chart (see http://peltiertech.com/Excel/Charts/ChartByControl.html),
using a combo to set an offset.
In this case I'd have a combo box of counties which return number
which is used as the offset. The relevant row is then used as the
source for the chart.
COUNTY WEEK01 WEEK02 WEEK03 WEEK04
Staffordshire 1.1 1.2 1.4 2.1
Derbysire 2.1 3.3 4.1 2.2
However, I have another spreadsheet that has the monitoring stations
within counties. There are hundreds so it wouldn'...Move a single org chart shape
This is a simple question (I hope). I am trying to reduce the vertical space
between the shapes at the top of my organizational chart. If I try to move
or nudge any one of these shapes, all of the shapes below it also move thus
making it impossible to close the gap. If I try using the "change spacing"
feature, it rearranges all of the shapes in my chart.
Any advice would be greatley appreciated.
The change spacing feature has several options, one of which is the Selected
Shape. That should allow you to change the spacing for that shape only. So,
i...How to chart?
Need Help Charting Data
I have data in the following format:
10-05-04 395032 33757864
10-05-04 394656 33757864
10-05-04 394704 33757664
10-05-04 385544 33740816
10-05-04 431360 33795440
10-05-04 419656 33798832
10-05-04 403472 33768480
10-05-04 447864 33843624
...Cannot create new mailbox
I'm having an issue of not being able to create a new mailbox. I can
go through the process of creating the user in AD Users & Computers
and everything is successfull. I can even see the user in the GAL. But
I cannot access the mailbox by opening it nor does it show up in
system manager even after sending a message to the mailbox. I do have
full permissions to the mailbox. It seems like it is not being created
even though the recipient policy seems to be working because it does
generate an address for the account.
Any help would be appreciated.
...how to insert chart for imported data in a report?
plz reply soon if you know
Please use the large white space under the subject to enter a detailed
question. It also helps to read some past threads that might pertain to your
question (whatever it is).
Microsoft Access MVP
"varsha from pilibhit" wrote:
> plz reply soon if you know
...how do i create a macro to export a chart to powerpoint?
Can anyone give me any tips to create a macro to export data to powerpoint.
When I try to record the sequence it falls over at the 'copy' stage.
Have you seen Jon's page on the subject?
Andy Pope, Microsoft MVP - Excel
"NPAT" <NPAT@discussions.microsoft.com> wrote in message
> Can anyone give me any tips to create a macro to export data to
> When I try to record the sequence it falls over at ...Error created when try to Print Preview or Print
When try to print or print preview system is generating an error:
"Print titles must be contiguous and complete rows or columns."
Used excel for years ever seen this error before.
Using Excel 2007 on Vista, we just upgraded to SP2 for both systems.
After testing a few times, I notice that system is generating a Name Range
with no referencing cell range, the name range is called Print_Titles.
If I delete the name range it removes the error message and able to use
print preview and able to print.
Notice it is occurring more ofter when client is copying a worksheet to ...Creating Excel Invoice Template
I have been trying to customize a downloaded template but was frustrated so
trying to create my own invoice. My question is once I input the formulas
how do I keep/save them ???? when I enter the first calcualtions all is well,
but if I go back and edit in the cell where the formula resides I lose the
formula ??? I am a relative newbie to this so any help will be greatly
appreciated. I have searched this site and cannot find a link to creating an
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions wit...Making charts equivalent
We track the average patient value on a number of different analytes.
Is there a standard way to make the graphs appear equivalent? If I
track hemoglobin with a mean of 14.0 with the minimum set at 10 and
the max set at 18, and then I have a second graph for hematocrit that
has a mean of 38, but the max is set at 41 and the min at 35, the
latter is a steep graph, and the former is flat, even though the
hemoglobin values are approximately 1.3 the hematocrit.
But the setting of the axis values can potentially make data look
misleading. I am looking for a rule so that data will appear
consist...Date format problem #2
Please suggest me the solution of my problem,
as i m handling data for 60,000 in no.Some body in data
entry has enter the date in a cell in gernal format e.g
20.03.2003 tht is 20th march 2003, i wnt to convert in the
date fomat,like 3/20/03.. i tried ..but i failed to tht
please suggest some alternative solution for tht..becoz it
is not possible to do it mannually
waiting for the response
Try using Data/Text to Columns. and assign the information as a date.
"Nishant" <email@example.com> wrote in message
news:090201c37ce0$1b...Pivot table sorting #2
I have a pivot table report for partnumber and values. This report is based
on a database containing details like
total value... etc.
In my report i would like to sort the table in descending order of total
value. I have tried advanced option by double clicking the total value
field and changing the autosorting option to descending(total). But i am
not getting the required result.
My version of excel is Microsoft office excel 2003.
Pivot table report is given below
...convert time into decimal #2
the formula above where E40 is the time now, and E44 is the time of 2 hours
ago. I want to return 2 instead of 2:00 PM. How do I do this? I do this
but it does not work (E40-E44)*24.
...comapring 2 seperate workbook
HELP!!! Is there any way you can compare 2 workbooks. for example,
would be looking for a match (of values) from single columb o
workbook 'a' to values of single columb from workbook 'b'. When eve
there is a match between these two, maybe I can write it on ne
workbook?(automatically). Or if there is any other tricks, please le
me know. (I am sick of comparing it maually and when there is a match
I am cutting and pasting to new workbook)
Message posted from http://www.ExcelForum.com
as a starting point have a look at:
http://www.cpearson.com/excel/duplicat.htm#Ex...CRM 1.2 SBS 2003 Can not install exchange email router
Logged on as domain admin throughout.
Installed CRM successfully, followed install instructions, did not install
to local host installed web to a hostheader of "companyweb" port 80.
during Exchange email router setup I get an error when specifying CRM
server and web - "one or more os the MS CRM servers you listed is invalid or
you do not have administrator priveleges on that server...."
server name: sbssrb01
If I go into IIS can not open CRM web get - http Error 403 - Forbidden:
Access is denied.
All services are on 1 server "sbssrv01&qu...Chart not to pull Zero's
I am working on an Excel Chart that has future months showing with a Zero
dollar value and it is charting the future months on my chart. Is there a
way to get it so that the Zero's will not show up? I have a formula that is
pulling the amount from another chart.
Thank you for your help.
Change "" to NA() in your formula. This puts #N/A into the cells, which is
unattractive in the worksheet, but which is not plotted on a line or XY
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
__...arrow keys #2
To move from cell to cell, I used my arrow and enter
keys. They no longer work in Excel. I have to click on
each cell to get there. Do you know how to fix it?
What happens when you use the arrow key? Check if your scroll lock is on or
you have something under tools>options>transition
"Shirley Smith" <firstname.lastname@example.org> wrote in message
> To move from cell to cell, I used my arrow and enter
> keys. They no longer work in Excel. I have to click on
> eac...How do I create a B&B reservation system in Excel?
Trying to create a reservation system for 6 room B&B in excel. Does anyone
have template or know where to get one?
...pie charts #9
How do I surpress the numbers from showing on a pie chart and just show labels?
Select the pie, not the whole chart, and right click it, select Format Data
Series ..., Data Labels tab, and select from there.
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Sara" <Sara@discussions.microsoft.com> wrote in message
> How do I surpress the numbers from showing on a pie chart and just show