Help with Fonts
I have a document created in MS Word 2002 version. When I am looking at the
font of this document some words have been highlighted as Arial pt 10 all
caps while other words which are also in capitals are only highlighted as
Arial pt 10. Any idea why only some of the words are highlighted differently?
Also any idea how we can avoid this from happening? Any help will be greatly
All Caps is a font property (like Bold or Italic); when it is removed, the
underlying text (in lowercase or Caps & lowercase) will be restored. If the
text has been typed in capitals (usin...Database Model Diagram #2
I have Visio 2003. When I try to load a new Database Model Diagram Visio
locks up every time. Every other type of template loads just fine. I have
Windows XP Professional x64. Is there something I'm missing? Thanks for any
This can occur with Visio 2003 on 64-bit Windows systems, and is related to
the way that Windows provides the Printer supported paper sizes which
Here is a work around that will help you avoid the problem:
1) new blank drawing
2) File | Print
3...Money 2004 Help files in XP
Money 2001 ran great in Windows XP. Have up-graded to
Money 2004 Deluxe. Installed and runs fine. However,
when trying to open the "help" files, get message "unable
to load topic". Installed in system running Windows ME
and NO PROBLEM. Apparently, the "help" files are NOT
where Money 2004 thinks they should be. Any "HELP" out
there? Have searched Microsoft Support, FAQ, Database,
etc... nothing on this. Has anyone else had this
Try deleting Internet temporary files from Internet Options.
"Susan" <sjchaney...Install Issues 12-26-06
I have 2 errors trying to install CRM, that are preventing install.
1. The organizational unit does not exist.
2. Service mssearch was not found on this computer. But when I check
services I find SQL Server FullText Search (MSSQLSERVER) and no mssearch.
...Initialize Second Dialog
I have a dialog application that I've created, and I can initialize a combo
box on this dialog box before it is shown. I also have a menu in this
dialog. A selection from this menu opens another dialog box...
However, when I try to initialize a combo box in the otherDiag through the
constructor, it doesn't work. I can add a button in otherDiag and once the
user clicks it, it will populate the combo box, but the constructor doesn't
do it. Any ideas?
"Saul775" <Saul775@discussions.microsof...Sheet Tab name #2
Does anyone know if there is a way to pick up the sheet name in a cell?
Workbook needs to be saved before the above will work.
You may wish to substitute the cellreference of the calling formula instead
of A1, if there is a risk of Row 1 or Column A being deleted at some later
"SS" <Student.firstname.lastname@example.org> wrote in message
> Does anyone know if there is a way to pick up the sheet name in a cell...2 if statements?
Is it possible to have 2 IF statements in the same cell?
...help with equation
I need help with my attendance sheet here is the scenerio total present over
total days (a&P)??? Thanks T
Or do you wan to give us more information and sample data?
(remove nothere from the email address if mailing direct)
"Tracy" <Tracy@discussions.microsoft.com> wrote in message
> I need help with my attendance sheet here is the scenerio total present
> total days (a&P)??? Thanks T
How can I use bar graphs for three different products with two axes becuase
of two different sets of info for each product and get the graphs to stop
plotting on top of each other? Please help!!
Jon Peltier has instructions for a column chart on two axes:
carrie in pa wrote:
> How can I use bar graphs for three different products with two axes becuase
> of two different sets of info for each product and get the graphs to stop
> plotting on top of each other? Please help!!
Excel FAQ, Tips &...convert number of seconds to date
I have an integer 1060128571 which is the number of seconds since
1/1/1970. The number evaluates to
So my question is given the start date is always 1970 how do I
calculate the end date e.g 6/08/2003 10:09:30.
if I divide 1060128571/60/60/24 I can get the number of days etc.
If anyone has an easy solutions,please send it on
Message posted from http://www.ExcelForum.com/
1/1/1970 12:00 AM equates to 25569. Divide the number of
seconds by 86400 (number of seconds in a day). Subtract
that from 25569 and format the cell as
m/d/yyyy h:mm:ss AM/PM.
I have a spressheet that automatically populates 2 cells with the current
time and date using the TODAY() and NOW () functions. Unfortunately, when I
go back into the sheet at a later date or time it repopulates the cells with
the new time and date.
e.g. First Visit date set to 5-Jan 05 and time set to 09:20 AM.
Second visit date set to 5-Jan 05 and time set to 09:25 AM.
Third visit date set to 6-Jan 05 and time set to 10:00 AM.
Is there a way that I can only get the cells populated once?
Any help would be appreciated.
Use Ctrl-: and Ctrl-Shift-;
(remove noth...PPT 2007 embedded charts help
I am using both Excel 2007 and Powerpoint 2007. I also program using console
applications and write code in C#. Is there a way to edit embedded chart
data using C#? We would like to keep the charts embeded but if we change the
data in Excel and copy of the chart the chart is now linked, maybe there is a
way to copy it as embedded instead?
The problem with the linked issue is whenever someone saves the PPT locally
and is no longer connected to our intranet they can no longer access the
excel file. Even if you pull the excel file over the linked file location
doesn't u...macro help #17
I am just learning Excel and I am trying to add a formula to some cells
to do multiple functions. Here is what I am trying to do: IF G2=1 and
H2=1, add "1" to E2 and delete G2 and H2. I have been told I need t
create a macro for this. Any help on how to do it
candyyoung's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2679
View this thread: http://www.excelforum.com/showthread.php?threadid=40054
I think your code (with no validation at all!) would look something li...Excel Charts #2
My problem is that I have a chart that I am creating a chart of tota
sales for new molds and products for our sales engineering guy for eac
year 99 to current. No problem, right? Wrong! He wants each bar t
be broken down in to top customers to show where the sales came from.
I have never done this - how do I accomplish two graphs in one
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com
What kind of a chart do you want? What would be on the x-axis? The y-
How are ...Help with switch to activate the remember password option
Using outlook 2K on WinXP Home Edition, I have noticed
that on some workstations, the remember password check box
option does not work. And yes, we are using the correct
password. Has anyone ever had this happen to them? We
just had a laptop do the same thing. What is interesting
is that the same machine (laptop) would remember the
password up until lately?
Any help would be greatly appreciated...
Incodently, this is also a problem in IE browser as well.
I am stumpped.
...OWA 2007 400 bad request
From on the LAN, I can get to OWA all OK.
From an external location, I first get a dialog box popping up. I enter
domain\name and my password, then get to the new OWA logon screen. I then
enter my domain\name and password again in the form but get
HTTP 400 Bad Request for the page
What Version of Exchange? Are you using a FE/BE configuration?
Are you using ISA to publish OWA or is there a firewall between server
and the external client?
When you get the HTTP 400, do you also see any of the following errors
i...CRM 3.0 Installation error 11-28-05
I am getting an error when CRM tries to create the root business. My client
is using an OU within an OU, installing under the domain admin account.
As soon as I can I am going to go over their setup one more time to make
sure permissions are all in place, but has anyone else run into this error?
Error| Install exception.System.Exception: Action
Microsoft.Crm.Setup.Server.ProvisionBusinessAction failed. --->
System.Runtime.InteropServices.COMException (0x80044151): Exception from
Microsoft.Crm.Platform.ComProxy.CBizOrganizationClass.IBizOrganization_Create...Help with an array and SUMPRODUCT
I am not positive that SUMPRODUCT is the right function to accomplish what I
am trying to do so I’ll start by describing my objective. I suspect the
solution I am looking for lies with some variation of SUMPRODUCT entered as
On one spreadsheet, in column A, I have a list of the names of people,
starting in row 2.
Across row 1, I have a list of meetings by date and topic, starting in
At the intersection of each row and column in the resulting array, I have a
binary value: 1 if that person attended that meeting, 0 if that person did
not attend that meeting...Can I add a borders toolbar to Excel 2000 like the one in Excel 2.
Can I add the manual borders toolbar to Excel 2000 like the boders toolbar in
Excel 2003? Thanks email@example.com
I don't use xl2003, but in earlier versions, I created my own toolbar:
Then dragged a bunch of icons from the Commands Tab (Format Category) to that
There's a bunch!
> Can I add the manual borders toolbar to Excel 2000 like the boders toolbar in
> Excel 2003? Thanks firstname.lastname@example.org
Thank you for an innovative answer. I have Excel 2003 on my desjtop and
Exc...Totalling a group of worksheets #2
How do I summarize a continguous series of worksheets on to a summary page?
e.g. I have a number of worksheets A,B,C,.......K. I also have a summary
worksheet. I want to total cells A1 in the group of worksheets and show the
total in the summary worksheet
On the Summary sheet, select the cell where you want the A1 summary to
Then click on the Sheet A tab
Hold the [Shift] key down
Click on the last sheet's tab
Release the [Shift] key
Type ) and press [Enter]
The formula should look like: =SUM(A:K!A1)
Does that help?
Regards...opening a Works 3.0 database spreadsheet saved on disk into excel 97
How can I convert or open a Works 3.0 database spreadsheet (from an older computer which is saved on a floppy disk) and save it into Excel 97 on a different computer?
...Flashing cells #2
Is there a way either conditionally or through a formula that I can get a
higher or lower figure to Flash in a color should it not reach the criteria?
On 2 Dec, 21:39, "Haggis" <IC006J4...@blueyonder.co.uk> wrote:
> Is there a way either conditionally or through a formula that I can get a
> higher or lower figure to Flash in a color should it not reach the criteria?
Many, many people have advised against using flashing. It looks dreadful.
Furthermore...How do I add a second y-axis in an xy(Scatter) chart?
I would like to create a xy-scatter chart for a dataset with two different
I have one set of data, but I need to plot it against two axis,
"concentration" and "dilution factor". The dilution (and therefore the
concentration) is not linear, so a line chart will display the data
"distorted" or "skewed".
I tried the tip from bj (9/9/2005 4:44 AM PST, to the question "Line chart
or scatter chart??")
> there can be two x axis in a scatter chart.
> first select one of the data series and <axis> select secondary
> next i...Reapply Service Pack 2?
I've been advised by my anti-spam vendor to re-apply Service Pack 2 for
Exchange. I recently uninstalled Outlook from the Exchange Server as I was
told it should never be on the Exchange box. Something about the un-install
of Exchange broke the anti-spam software and they say it's a CDO issue.
Is this sound advice? Anything I should be aware of when re-applying the
It is a single server environment, E2K3 SP2 running on Windows 2000 Server.
Thanks in advance,
Robbit - IT Manager
On Fri, 16 Jun 2006 11:55:02 -0700, Robbit
<Robbit@discuss...iCalendar request performs differently #2
This is a multi-part message in MIME format.
I use a program that uses SMTP services running on windows 2000 to send
meeting request to users as a iCalendar request (ics attachment).
Anyone that is using Outlook XP who reply's to the request, the
organizer will get the response. If the same recipient uses Outlook
2003, and reply's the appointment is added to their calendar, but the
organizer never gets the response.
Also in Outlook 2003 the "Prop...